populate to a table or query

[Revned]

hi,

i have this formula in my textbox from my main form
=[qryOrders subform].Form.invoiceNumber


i want to populate the value from this textbox to my table tblOrders

can anyone help with this

thanks

 

[Arvin Meyer [MVP]]

What are you trying to accomplish? Typically, the InvoiceNumber would
originate on a main form if it were stored in the tblOrders table. It would
be the linking child field that is then automatically filled in on a subform
and the OrderDetails table.

 

[GBA]

not clear but it seems that you need to learn the INSERT query or UPDate
query...just fyi though a single value is problematic as you must have also a
value to tell the query which record is to be updated....so one tells it that
for Record X update Field Y to this value....

 

[Revned]

thank you very much Arvin Meyer and GBA
it works now thru child/master link fields
thanks a lot

i really appreciate

What are you trying to accomplish? Typically, the InvoiceNumber would
originate on a main form if it were stored in the tblOrders table. It would
be the linking child field that is then automatically filled in on a subform
and the OrderDetails table.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

hi,

i have this formula in my textbox from my main form
=[qryOrders subform].Form.invoiceNumber


i want to populate the value from this textbox to my table tblOrders

can anyone help with this

thanks