I am trying to capture the value of a textbox and update a feild in a table with it. Anyone have any suggestions on how to accomplich this? I have tried an update query but I can't get it to work.
Either set the recordsource of the form to that table and then set the control source of the text box to that specific field (which will automaticall update the table)...or use VBA...open up a recordset and find the record you want to update. The first way would be the easiest...hope that helps.
Unfortunatly the first wont work. Only under certain circumstances does the feild need to be updated. I am not sure how to declare a record set and do it that way.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.