General information
Category:
Coding, syntax & commands
Title:
Using a Combo Box value as a paramater to another ComboBox
Hi.
I Have two CboBoxes on a form, one is depandent on the other as follows:
Both are set up with row sources as sql select commands
CboBox1: Select MyArea from MyFile into Cursor Cur1
cboBox2: Select MyAreaSub,MyArea from MyFIle1 where MyArea = Thisform.cboBox1.Value
This gives an error :- Thisform can only be used from within a method.
It there any way round this where the source of the second combo box is dependent on the value in the first one.
Regards,
Gerard
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only