Unbound Box

  • Thread starter Thread starter Beep Beep
  • Start date Start date
B

Beep Beep

I would like to put a "Unbound" box on a form (Switchbox) that then asked for
input of a store number in order to pull up the appropriate querry. In other
words I want the querry to run after they input an individual store number
 
What do you want to have happen when they put in a wrong store number?

Rather than force the user to remember/use "store number"s, consider using a
combobox that lists all valid stores (OK, store numbers too, if
necessary!<g>). That way, the user doesn't have to get corrected ... !


Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff:

I can see that they could put in the wrong store number, however I have
roughly 500 stores. This is why I was thinking of just having an error
message of invalid store number or something like that. What do you think? I
can do either.
 
Jeff:

I can see that they could put in the wrong store number, however I have
roughly 500 stores. This is why I was thinking of just having an error
message of invalid store number or something like that. What do you think? I
can do either.
Click to expand...

I believe Jeff answered your question.
Use a combo box that lists ALL the stores and their ID Numbers. That
way all the user needs to do is pick the already listed store, rather
than remember the ID number. Set the Combo LimitToList property to
Yes.
No 'wrong' entries because all the 'right' ones are already in the
list.
 
I can see that they could put in the wrong store number, however I have
roughly 500 stores. This is why I was thinking of just having an error
message of invalid store number or something like that. What do you think? I
can do either.
Click to expand...

It's always kinder to the user to give them a choice of valid values rather
than making them type in something blindly and then slapping their hand if
they do it wrong.
 
Back
Top