DLookup Combobox with Duplicates

J

JOM

I have a combox on my form that is used to search for a Rqst#. What I would
like it to do is prompt the user that there are several rqsts with what they
have just typed if any. Therefore the prompt should look like this

NB: There are 2 similar Rqst#

if possible, it should list the Rqst# and the Rcvd#(the primary key---
autoNumber)
therefore the prompt should look like this
0000 ---- 1
0000 ---- 4
whereby the 0000 represent the Request# and the 1 and 4 represent the Rcvd#

Please help!
 
A

Al Camp

JOM,
Why not just add the RcvdNo column to your combo. That would force
RqstNo to break into seperate combo entries for user selection.

Just a tip... don't use the # symbol in field names. In Access, # is
associated with Date parameters. Somewhere along the way, that may cause a
"hard to shoot" bug in your code.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
J

JOM

Well, I don't this would help, currently the user is just typing the rqstNo
in the combox, and the first one they see is what they do whatever they need
to do to it, but unfortunately, there could be several of them and they just
did not bother to check so that is why I need a popup prompt.

The RcvdNo. will make it cumbersome in the combobox to search, I only
mentioned it, if possible to prompt the user that the RqstNo are associated
with the the following RcvdNo.

JOM!
 
Top