Microsoft Access

[jaggar]

I have a browse form with two combo boxes, box A and box B.
Both boxes use the same table. My problem is how do I set
the value in box B to the value that was retrieved based on the selection in box A and vice versa.

 

[jsaliers]

I have had a similar problem, and have since solved it. Check out this thread below.

thread181-456002

It is located in the same forum. It is listed as:

"MS Access Database - Auto-update textbox conditionally"

 

[evalesthy]

http://www.tek-tips.com/faqs.cfm?spid=702&sfid=681

Is this what you want to do?

 

[jaggar]

I have a form with 2 combo boxes. One box presents a list of SSNs and the other a list of Last names. How do I clear a previous selection? For example, I click SSN 111111111 which returns data for that SSN. Later I click the second combo box, Last Name Smith. I want to clear the combo box containing 11111111 because Smith's SSN is not 11111111. How do I clear the last selection to prevent confusion?

 

[evalesthy]

Try Me.cboLastName = Null to clear the selection. You could run it on the afterUpdate event of the other combo box. After the "Me." you will insert the same of your SSN combo box.

 

[jaggar]

Thanks for the prompt response, evalesthy. Your suggestion worked.