Passing data from a form to 2 seperate tables

C

cooper

Hello,
i have a form that after it is all filled out and all my checks are
performed the user clicks a button to run a macro that does the heavy
lifting.
my user currently has to enter the data from 4 of the forms text boxes
into one of my parameter queries. Is there a way to do this with automation?
 
D

Damian S

Hi Cooper,

You could either have your query pick the value up directly off the form
using forms!FORMNAME.FIELDNAME, or you could build an SQL Query String to
insert the data for you.

Hope this helps.

Damian.
 
Top