Vba to move data from table to table

CharlesWh

Registered User.
Local time
Today, 21:40
Joined
Jan 19, 2006
Messages
36
Have searched for answer but cant see.

I have a form with three dropdown's, each assigned to their own query. On the form I have a 'Close & update' button. I want to create some code which, on button press, will take my selection and pace data into another table with corresponding field names. It is important that i can copy data to a table rather than using relationships/associations.

any pointers on where to look for beginners guide to vba?
 
Hi CharlesWh,
Have you already tried binding your form to the query/table you wish to update and then binding your ComboBoxes to the fields you need updated? No additional code is required.
 
no, thanks for the tip. i will investigate bindings and soforth.
 
Hey! Managed to do something resembling what I need. Loads more to know but your help enabled a real LEAP forward. Many thanks for offering a pointer to the solution as asked for. REAL HELP. Thanks.
 

Users who are viewing this thread

Back
Top Bottom