Passing data from a form to 2 seperate tables

  • Thread starter Thread starter cooper
  • Start date Start date
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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data entry for a table from a form 2
Access Passing data from a form to another form! 0
Data entry to table from a form 1
Access Passing the value to a table 1
Passing a Parameter into a MS Access 2007 Form 0
Creating a Form from Multiple tables 1
Populating data to subform from main form 0
Using an append query in a subform 1

Back
Top