The bound column of the combo box should be unique. It would help if you provided the row source. Are eventNumber and ReviewNumber other bound fields on the form?
Duane Hookom MVP
MS Access
----------------------------------------
> To: MS_Access_Professionals@yahoogroups.com
> From: jfakes@rocketmail.com
> Date: Thu, 20 Dec 2012 22:43:48 +0000
> Subject: [MS_AccessPros] Combo Box lookup on two fields in MS Access 2003
>
> I've been asked to create a lookup on a form on two fields. The first field is EventNumber and the second field is ReviewNumber. I tried building the lookup, however, when I search for Event # 50 review 2, the form goes directly to Event 50 review 1. How can I force the lookup to go to Event 50 review 2, then display 50 rev 2 in the combobox? I also want the combo box to synch up to the event number and review number when the user moves to new records using the record selector.
>
> I tried googling the issue but never found exactly what I'm looking for.
>
> John F
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar