How does the info entered on a form get to the table

  • Thread starter Thread starter DeniseP
  • Start date Start date
D

DeniseP

I have two forms, one a purchase order and the other a supply order. I do
not know how to get the info entered into the forms to be stored in the
tables. The forms will be visited twice. Once to fill in the info and then
second to mark completed when the order is received. I also want the info
from both forms when completed ( supplies received) to update a third table,
inventory. Any help for this novice would be greatly appreciated.
 
hi,
you should use an append query to move the data in each
control to the tables
see help on append querys.
to mark complete- use an update query
see hekp on update querys.
to update the inventory- update qerry.
It can also be done with recordset but you probably should
stick to action querys right now. And you have a little
reading up to do.
 
Back
Top