Message (1 Viewer)

[Lady Gragor]

I have two sub forms on the main form. On one sub form, the user selects a job number from cbo_JobNo. If the person selected on the other sub form is not person1 or person2 then I would like a message "You cannot use this job number". Could I have some advise on the best way to do this please.

 

[RuralGuy]

You would put your code in the BeforeUpdate event of the cbo_JobNo ComboBox.

 

[Lady Gragor]

Yes I understand that part thanks RuralGuy but I am not sure on the code?

 

[RuralGuy]

See if THIS LINK helps a bit with the syntax.

 

[Lady Gragor]

Thanks I'll give it a shot

 

[RuralGuy]

Post back here if you are still having trouble and give us what you have so far.