Synchronized Combo Boxes.

R

Rachel

I have 2 synchronized combo boxes - one with the TRNG_CODE and the other with
the various descriptions for classes under each TRNG_CODE. Everything works
great except that if I have multiple descriptions for one code, it will only
let me choose the first description. All of the multiple descriptions
display in the combo box when the TRNG_CODE is chosen...but it will not let
me choose anything else but the first one displayed.

The code for the TRNG_CODE combo (cboFind) is below with the row source
being a value list I typed.

Private Sub cboFind_AfterUpdate()
cboFound.Requery
cboFound.SetFocus
End Sub

The other combo box's code is below with the row source being a query
containg the TRNG_CODE and TRNG_DESC with the TRNG_CODE criteria being: Like
[Forms]![TRAINING INPUT TEST2]![cboFind].

Private Sub cboFound_AfterUpdate()
Me.Painting = False
DoCmd.GoToRecord , , acFirst
Do Until Me!TRNG_CODE = Me!cboFound
DoCmd.GoToRecord , , acNext
If Me.Recordset.EOF Then Exit Sub
Loop
Me.Painting = True
End Sub


Hope this is enough info for a response...please help! :)

Thanks,
Rachel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Can't go to specified record" error 3
Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
2nd search box not sort properly after using 1st search box 1
synchronized Combo Boxes in subforms 2
Search last name and first name combo box 6
Find correct record after user using down arrow 4
Synchronized Combo Boxes 3

Top