open form IF

  • Thread starter osupratt via AccessMonster.com
  • Start date
O

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.
 
D

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

won't let you into form if textbox entry not found in table 5
user name and location 2
Creating a Chart on form from selected data in query. 0
Generated text copies into another template 0
Copy previous record into form field 0
Excel does not accept text format! 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
How do I clear a form? 0

Top