Solved change the value in combo box

[Safari]

hi all

can any one edit my attached data base :
i want .. when i change the value in combo box named " itemsname " in form " invhead " to anther item name in the same combo box it should also changes in table "StoreTransaction" too and update it .

thanks

 

[mike60smart]

Hi
I looked at the relationship between your Main Form - "InvHead" and the related Subform "InvDetail"

InvDetail did not have an Autonumber Primary Key - I added it as "DetailsID"

What has the table "StoreTransaction" got to do with the other 2 tables? How is it related to these tables?

 

[Cotswold]

You will need to look up Refresh, Requery, RePaint, RepaintObject and referring to Objects and Variables on a form in the Language Reference.

You need to understand how the syntax works, ie:

[Forms]![FormName].[Form]![VarName]
[Forms]![FormName].Requery
[Forms]![FormName]![VarName]
[Forms]![MainForm]![SubForm].Form!FieldName.Refresh
[Forms]![MainForm]![SubForm].Form.Requery

If you want to update a Table, run an Update Query.

No point in doing it all for you, it won't help in the understanding. I'd advise you to read through the Language Reference. Might be a bit boring but is essential at some stage.