I'm trying to write a simple macro that says if a particular field on a form is checked Yes (the default is No), then open another form based on the same record as current record.
Basically, I have a real estate database that has a checkbox on the main form concerning properties. The field is "Leased". The default for the field is "No".
I then have a form for the main table where, if a user clicks the checkbox to indicate that the property is leased, then I want it to open another form, "Lease Info", where the user can then input the lease information for that property.
When I try to write an If statement using the actions available when creating a macro, I get a Type Mismatch error. I changed my syntax to "False" rather than "No" in the expression, and now it says it cannot locate the main form?????
Basically, I have a real estate database that has a checkbox on the main form concerning properties. The field is "Leased". The default for the field is "No".
I then have a form for the main table where, if a user clicks the checkbox to indicate that the property is leased, then I want it to open another form, "Lease Info", where the user can then input the lease information for that property.
When I try to write an If statement using the actions available when creating a macro, I get a Type Mismatch error. I changed my syntax to "False" rather than "No" in the expression, and now it says it cannot locate the main form?????
