Share this question

Welcome to Teachnovice Q&A, where you can ask questions and receive answers from other members of the community.

This is a collaboratively edited question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Update Combobox Fields via an Access 2013 Form?

0 like 0 dislike
234 views
Simplified version:

I would like to update a table field based on a combobox:

SELECT [Table].[ID], [Table].[Name] & " " & [Table].[Year], [Table].[Info1], [Table].[Info2], [Table].[Info3] FROM Master ORDER BY [Name], [Year] DESC;

How does one go about changing the value of [Table].[Info1] AKA Combo1.Column(3) -- so that the table itself is updated too?

Thank you for your kind suggestions,

Stumped

Update: figured out how to properly use UPDATE and Execute--works ok
asked Jan 26, 2015 by Stumped  

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.
...