change a record in table from a form vb code

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

Guest

i want to update in a table the qty from a form. i used
[Forms]![frmsold]![frmsold subform]![qty] = [Forms]![frmsold]![frmsold
subform]![qty] - [Forms]![frmsold]![minusQty]
but then i tryed
![tblchina]![qty] =
![tblchina]![qty] -
[Forms]![frmorders]![frmordertransactions subform]![qty]
i just cant find the syntex for using tables.
 
You cannot directly address tables in VBA. You can either create an Update
query and run it from VBA or you can open the table as a recordset and update
it. The easier way would be to write an update query, probably.

In eiter case, you will have to identify which record in the table to update.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Reference Subform's Control 0
Syntax Error in a SQL string 3
copy data 8
Integers aren't working 5
Add/Subtract columns from tab to tab in same file 3
Assign the records shown in a subform to a recordset 2
Need help on how to pass calculated field from a form to another form 0
AddNew method problem. pls help. 3

Back
Top