Select Record When Duplicates In Drop Down Selection List

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I used the combo box wizard, selecting the "find a record on my form based on
the value I selected in my combo box". The list is a list of purchase orders
sorted by customer name. Each customer can have several PO's. If you select a
particular record from the drop down list, it does not retrieve that record
into the form. It retrieves the first record for that customer. Is there a
way to have is fetch the exact record being selected? Thanks!
 
It sounds like the bound field on your combo is the customer name and
not the PO

Look at the code that the combo box has on change. you will have to
change that part of the logic. I am assuming that both the PO and
customer name are showing in the dropdown.

It is probably loading the arguments with
[customer] = me.comboname

will need to be changed to correspond to

[yourPOfieldname] = me.comboname.column(1)

the # is zero based and is the column number of where the PO shows up
in your query that supplies data for the combobox.
You may have to expand that logic if the PO # is not unique.
 
Back
Top