G
Guest
Combo box lists all offices. Need to limit selection to one of three choices
(offices in certain regions) in Option Group. How does one do that?
(offices in certain regions) in Option Group. How does one do that?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Michel Walsh
Hi,
Change the rowsource property, in the gotFocus event of the combo box, as
example.
Dim str As string ' to hold temporary SQL statement
str="SELECT fieldName FROM tableName WHERE
RegionID=FORMS!FormName!FrameControlName"
If str = Me.ComboBoxName.RowSource then
'do nothing
Else
Me.ComboBoxName.Rowsource= str ' that implicitly requeries the list
End If
Hoping it may help,
Vanderghast, Access MVP
Change the rowsource property, in the gotFocus event of the combo box, as
example.
Dim str As string ' to hold temporary SQL statement
str="SELECT fieldName FROM tableName WHERE
RegionID=FORMS!FormName!FrameControlName"
If str = Me.ComboBoxName.RowSource then
'do nothing
Else
Me.ComboBoxName.Rowsource= str ' that implicitly requeries the list
End If
Hoping it may help,
Vanderghast, Access MVP
G
Guest
thank you . . . I was still stuck. Beginner/Novice Acess user. I will try
this and get back with you hopefully to tell you of my success!
Tom
this and get back with you hopefully to tell you of my success!
Tom