Appending Data

  • Thread starter Thread starter T Liden
  • Start date Start date
T

T Liden

I need the users to view the data in the query before they append the data
to a table. I thought about having a button on a form that would bring up
the query and then have a button on the form that would run the same query,
but as an append query. If this is the best way of approaching this, how
would I pass the parameter from the query to the append query so that they
would not have to enter the date again when the append query is run? If
there is a better way of doing this please let me know.

Thanks in advance for your time!!
Tim
 
Well, have them enter the date on a control on the form and then refer to the
control in the query.

SELECT ...
FROM ...
WHERE DateField = Forms!FormName!ControlOnForm

Then your buttons on the form could call the two queries.
 
Back
Top