populate to a table or query

  • Thread starter Thread starter Revned
  • Start date Start date
R

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
 
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.
 
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....
 
thank you very much Arvin Meyer and GBA
it works now thru child/master link fields
thanks a lot

i really appreciate

Arvin Meyer said:
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


Revned said:
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
Click to expand...
Click to expand...
 
Back
Top