Appending data from a form in an Append Values Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In an Access database append query, I could put Forms!frmOrders.OrderID
in and append it to an order details table. I can't seem to be able to do
this now that I am using a SQL database in an Access Database Project (.adp).
The 'Build' option is no longer available to help me either.

Could someone point me in the right direction please? I basically want to
append data entered on a Form to another table.

Thanks
Ian
 
Looks like we're all stumped on what should surely be a basic requirement for
a database app? Can anyone put me out of my misery?
Thanks
Ian
 
Back
Top