Synchronzied Combo Box

T

Theresa

Hi:

I have 2 combo boxes on a subform, cboRepl_Fixture and cboLamp. I have the
following code in the AfterUpdateEvent of cboRepl_Fixture:

Private Sub cboRepl_Fixture_AfterUpdate()
Me.cboLamp.RowSource = "SELECT Lamp FROM" & _
"Replacement_Lamp_tbl WHERE Repl_Fixture_ID = " & Me.cboRepl_Fixture
& _
"ORDER BY Lamp"
Me.cboLamp = Me.cboLamp.ItemData(0)
End Sub

When I view my subform, cboLamp is blank. I have adjusted the number of
columns to 2 and adjusted the width to see both, but it is still blank.

What am I doing wrong?

Thanks,
 

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

Synchronized Combo Boxes 3
Synchronized Combo Boxes 3
Clearing combo boxes and a text box 2
Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
Combo box 0
Combo Box Choose Record Problem 8
Synchronized Combo Box Not Working 3

Top