Synchronizing two combo boxes

E

Erik Gjertsen

I wish to synchronizing two combo boxes.

I have try the following solution:

I have made 2 Combo boxes. The first combo boxes name is cbofirst
In the properties Rowe Source Type: Value List
Row Source: ;A;B;C;D;F

Private Sub cboFirst_AfterUpdate()
cboFind.Requery
cboFind.SetFocus
End Sub

The second Combo Boxes name is cboFind.
In the Properties:Rowe Source Table/Query
Row Sourse:QrySecond

Private subFind_AfterUpdate()
Me.RecordsetClone.FindFirst " CategoryID = """ & Me!cboFind & """"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

I have made a Query by name QrySecond.
CategoryID and CategoryName
Criteria in CategoryID: Like[Forms]![FormName]![cboFirst] & "*"

But it still not work. No error comes up.
Can some one help me.

Thanks
Erik Gjertsen
 

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

Top