Macro that changes value based on a date input in another filed

[onka]

Hello,



Could you please help me with one macro? I have a simple form with fields from my user table. I have a field "user disabled" where you can specify date (or pick from a calendar), and there is another field called "status" where I have dropdown menu with currently two options: Enabled and Disabled. Is there a way to create macro that automatically changes "status" field value to disabled when "user disabled" field contains date? And if its empty, user will be automatically in Enabled status?

Thank you !

br
Onka

[ranman256]

Not a macro, a query does it. Use the macro to run an update query. The query uses the fields on the form as critieria.

update [status] from table Set [status] = forms!frmUser!cboStatus

[onka]

Hi ranman,

thank you for answer. I will try that!

br
Onka