open/close form and update field

[Phooey]

H
From an assigned command button ie. [yes] i want to update the relevant record in a field in a table (ie. with a 1 or a 'yes'), close the current form and open another form. The closing and opening i have no problem with - but i cannot get the table to update from my macro

can anyone step me through this procedure please

thanks - Phooey

 

[Steve Schapel]

Phooey,

If the field you want updated is represented by a control on the form
where your command button sits, you can use a SetValue action...
Action: SetValue
Item: [NameOfControl]
Expression: whatever it is

If it is in a table that is not part of the form's recordsource, you can
make an Update Query to update the value of the field to whatever it is,
and then use an OpenQuery action in your macro to run the update when
the button isa clicked.