Form button

Prayder

Registered User.
Local time
Today, 18:57
Joined
Mar 20, 2013
Messages
303
Is is possible to have a form command button add data into several columns in a table through vba?
 
yes, (less vba, more querys/macros)
have the button execute a query, docmd.openquery "quUpdFields"

your query will use the form values and post in the table...
similar to
quUpdFields:
update table ([field1], [field2]) values ('" & forms!frmMain!txtBox1 & "','" & forms!frmMain!txtBox2 & "')"
 

Users who are viewing this thread

Back
Top Bottom