Appending data from a form in an Append Values Query

[Ian Bateman]

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

 

[Ian Bateman]

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