update after saving a form in the forms field to another tables filed

[sireesha]

in access 2007, I have a form in that when i save the form sold is yes so this sold field value is automatically update to other table's flag. after saving has been done in the form update to other tables field to yes. how




please help me.

[June7]

Why are fields in different tables dependent on each other?

Run UPDATE query.

[sireesha]

i have a purchase table and sale table. once sale is done from form i.e., when i click on save button in sales form . automatically update to purchase tables flag field would be yes. how please give me update query. is it possible to attach the query for embedded macro save button.

[June7]

I don't know your data structure so can't be specific. I don't use macros, only VBA which would be something like:

If Me.checkSold = True Then CurrentDb.Execute "UPDATE tablename Set fieldname=True WHERE fieldname=" & Me.ID

I suppose you can have a saved Access query object and use macro to run the query.