open form IF

[osupratt via AccessMonster.com]

On my switchboard I have a selection 'enter field ticket data'. this will
open a form for data entry purposes. what i would like to have happen is that
when someone selects this from the switchboard a form pops up asking "what
location?".

If the user isn't in a back end table entered in for this location (table
consisting of username and location fields) then a message box would pop up
stating "you are not authorized to enter for this location".

How could this be done? Thanks in advance for any help.

 

[DStegon via AccessMonster.com]

Sorry, but this doesnt make a lot of sense. What do you mean "in the BE"
table? Do you have the program split into FE and BE but you only allow
someone to enter if they are in the BE?? Dont understand that thinking. Is
that what you are doing?