Help with dual entry selection

  • Thread starter Thread starter Radar
  • Start date Start date
R

Radar

Hey guys.
My vendors are causing me problems with dual reorder numbers.
I know I have to change my table to allow duplicate numbers'
How do I get the a box to come up and let the user choose between
items with the same reorder number, and have it entered into my line
items.


Thanks
Radar
 
Radar said:
My vendors are causing me problems with
dual reorder numbers.
Click to expand...

Perhaps a little clarification would be in order. Like what are "dual
reorder numbers" and how are they causing you problems.
I know I have to change my table to
allow duplicate numbers'
Click to expand...

Maybe, maybe not. We surely don't know enough to advise from this
information.
How do I get the a box to come up and let
the user choose between items with the same
reorder number, and have it entered into my line
items.
Click to expand...

First, consider that we don't know what your business or system is like,
don't know if there is good reason for duplicates, don't know how you are
keeping your data, don't know what the record source of the form on which
you want to put the control to let the user choose, and then clarify so
someone might be able to help.

My guess is that you'd use either a Combo Box or a Subform to let the user
choose between items with the same reorder number. But, given the
information here, it'd only be a guess.

Larry Linson
Microsoft Access MVP
 
Back
Top