Where clause in syncronized combo boxes

K

Krisse

cboFacility is a text field, and the following doesn't
but " " around the results of Me.cboFacility into the data
source of cboBasepath. If I go there and put the " " in,
my second combo box works.

Any ideas? THANKS!

Private Sub cboFacility_AfterUpdate()

Me.cboBasepath.RowSource = "SELECT Basepath FROM
tblFacilityBasepath " & _
"WHERE FacilityCode = " & "" & Me.cboFacility & ""

Me.cboBasepath = Me.cboBasepath.ItemData(0)

End Sub
 

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

Creating a Search using a combo box and then creating a report. 4
Dynamic Naming of Form Button 3
syncronized combo box 1
Synchronize combo boxes 2
my combo boxes 2
synchronized Combo Boxes in subforms 2
filter on combo box possible? 1
Where clause 4

Top