General information
Category:
Forms & Form designer
Barbara,
Thank you for your time.
Yes, the correct name is only in one record.
You could look at as, one name in four languages. The problem is you don't know which language you will find it. Hence, three card monty:). That is why I want to populate each combo with distinct. If I use fields as the RowSource I have blank fields to search through.
The key here, once the name is selected the other three need to be seen in order to compare and update the documentation.
Peter
>If you're only looking for one name, why use 4 combos? You can use the JOIN command (or a series of SQLs) to get a single cursor with a distinct list of all the names in all 4 fields. Or will you need to find "Berkeley" in combo1 sometimes but "Berkeley" in comb2 other times? In other words is any given name found only in one record, one PK at a time?
>
>
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only