Help with forms

A

Alex

I´ve been searching for a while and can´t find a topic related to my problem.
Hi, hope that someone can help me with this!
I have two forms CM-OR related to a table ORÇAMENTO and the form CM-EC
related to the table ENCOMENDA.
I need to insert a checkbox, named ACEITE on CM-OR, and activate it when the
number inserted on the field ORÇAM (from table ENCOMENDA) of the form CM-EC
is equal to the field NºORÇAMENTO (primary key of table ORÇAMENTO) of the
CM-OR form.

Thanks in advance
 
K

kingston via AccessMonster.com

Use the AfterUpdate event for ORÇAM of CM-EC to check equality and to enable
the check box. The check box control will always be present in the form so
there is no insert operation; you can either enable/disable it, lock it, or
hide it.

If Me.ORÇAM = Forms!CM-OR!NºORÇAMENTO Then
Forms!CM-OR!ACEITE.Visible = True
Else
Forms!CM-OR!ACEITE.Visible = False
End If
 
Top