Multiple Linked Selectors on a form?

[MikeLiberty]

Hi,
I don't have a lot of time to devote to learning Access Forms for this project so I'm hoping someone has a quick and dirty solution for me. I have a table with a number of fields. Most importantly, ID, Name and Notes. I want to create a form for end users to enter notes for a record. Some users will be look up the record by ID and some will want to use Name.

Is there a way to link separate controls together, so that if I select the value I want in one, it will pull up the notes field for that record AND update the other selector to reflect the correct value?

For example:
If I pick ID 1234, I will see John Smith in the Name selector and John Smith's Notes field. If then decide I want to look at/edit Jane Doe's notes, I can select her name from the Name selector and her ID 9876 will update on the ID selector.

I've been able to get 2 separate combo boxes to control the same notes field on the form, but i can't figure out how to connect the values in the combo boxes.

I want separate combo boxes so that the user can search by typing either the ID or the name (the lists are pretty long) and if I include both the ID and the name in the same combo box, I can only type in which ever field is first.


Thanks for the help. I'm off to go find a question to answer in the excel forum so I don't feel like a leech.

 

[alansidman]

Give this a try:

http://www.datapigtechnologies.com/flashfiles/recordsetclone.html

Alan

 

[MikeLiberty]

Give this a try:

http://www.datapigtechnologies.com/flashfiles/recordsetclone.html

Alan

Thanks, I'm able to get one combo box to update the notes field, but the other combo box still shows whatever was previously selected. What code can I use to make the PIN combo box = the appropriate PIN for the name selected or vice versa?