Please Help!? Linking Option Groups and Combo Boxes!

#1 September 12th, 2005, 12:39 PM

I would like to be able to select an option box which would activate a combo
box, from which a selection can be made. Much like the Northwind Sales Dialog
Box. I am having a little trouble! Please Help.
Cheers People!
--
Regards

Ashley Smart

#2 September 12th, 2005, 04:28 PM

Set the combo box' default Enabled property to No in form design view, and
enable it in the AfterUpdate event of the Option Group.

If Me!YourOptionGroup = YourSpecialValue Then
Me!YourComboBox.Enabled = True
End If

If your form is not a dialog form like the example you mention, but is bound
to a RecordSource, you will need to set the property in the form's OnCurrent
event:

If Me!YourOptionGroup = YourSpecialValue Then
Me!YourComboBox.Enabled = True
Else
Me!YourComboBox.Enabled = False
End If

Sprinks

"A. Smart" wrote:

I would like to be able to select an option box which would activate a combo
box, from which a selection can be made. Much like the Northwind Sales Dialog
Box. I am having a little trouble! Please Help.
Cheers People!
--
Regards

Ashley Smart

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Allowing only certain user Groups to change a combo box	Sam	General Discussion	3	August 4th, 2005 01:50 PM
Option Groups	Penny	Using Forms	1	June 1st, 2005 10:44 PM
selections based on a option button and a combo box.	talktobatchu	Using Forms	2	April 22nd, 2005 07:55 PM
Combo box doesn't show correct field	carriey	Using Forms	1	March 29th, 2005 11:05 PM
Modify records	Bernd	Using Forms	11	October 13th, 2004 12:00 AM