ProblemI with Goto command

[saschmeling]

Hi,

I am working on a database that has a field which is required. I was trying to make so that if they clicked out of the field- a message box would pop up warning them that this field is required, then go back to the field. I should specify that this is Access 2010.

I created a Macro which states the following:

Field is lngID, Field is required

Macro:
Before Update:
If lngID is Null

Add Action
Message Box
Message: Please enter the ID.

Add Action
GoTo Control
lngID


Any help in this matter would be greatly appreciated.

Thanks,
Scott

 

[BrianMH]

Is this in a form or are you talking about editing the table data directly?

 

[saschmeling]

Is this in a form or are you talking about editing the table data directly?

The Macro and control are in a form.

field was set as required in Table.

Thanks,