PC Review


Reply
Thread Tools Rate Thread

Synchronzied Combo Box

 
 
Theresa
Guest
Posts: n/a
 
      17th Aug 2009
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,
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cascading Combo Box - filling a text box instead of a Combo box =?Utf-8?B?U2N1ZGE=?= Microsoft Access Forms 5 25th Jun 2007 06:46 PM
Hashtable.Synchronzied() bernardpace@yahoo.com Microsoft C# .NET 3 30th Sep 2005 06:15 AM
Error Message: Windows cannot find 'box,box,box,box,box' =?Utf-8?B?Ym91Y2hhcmRwaWU=?= Windows XP Help 2 25th Jul 2005 08:47 PM
Create Protected Word template that uses combo box & combo box val =?Utf-8?B?Q2luZHk=?= Microsoft Word Document Management 1 1st Apr 2005 05:10 PM
Combo Box - Hide Combo Box w/Check Box =?Utf-8?B?UGF1bA==?= Microsoft Excel Programming 5 3rd Dec 2004 11:58 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:10 AM.