error trapping problem

• mattbristow

  SSC Veteran

  Points: 270

  More actions

  May 25, 2005 at 5:28 am

  #163836

  Hi

  I want to force a user to select an option from a dropdown menu before they can enter other data as this creates certain autonumbers etc depending on the selection.

  I am using an Access adp file as a client as well

  Thanks in advance for anypointers

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  May 25, 2005 at 8:07 am

  #560970

  I'm not really sure I understand your question but can you not ensure that something is selected from the dropdown box when the user tries to enter "other data" - not allow them to enter data UNLESS something is selected ?!

  You could use a variable to capture the selected option and if this variable = "" when the user is trying to enter "other data" - you could display a msg forcing them to select option first and exit the sub...

  You might also want to post this in the ACCESS forum..

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**