Multiple Combo and Subform

[Guest]

I have been working with a form that I could really use some assistance or
suggestions. You see, I have (2) combo boxes and a subform that works
together. When selecting combo1, it generates records in the subform and
limits what is available in combo2 for selection to narrow the search. Now
the code that have is:
Private Sub cbo1_AfterUpdate()
Me!cboAppID = Null
Me!cboAppID.Requery
End Sub
I have nothing for combo2 or the subform and not sure if I should. If so,
could you provide an example or lead me in the direction to make this work.
Only combo1 is linked to the subform, child & master. Thanks in advance!!

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access sample
database called: "CascadingComboBoxes.mdb" which illustrates many different
scenerios for using cascading comboboxes. One of them shows how to do it on
a subform. It might also be helpful to look at the sample named:
"SubformReference.mdb" for more help on referencing objects on subforms.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

You just don't know how much you have helped me - thank you so much. But I
do have another question? I am getting an run-time error: 3001, arguments
are of the wrong type or out of acceptance range or conflict with one
another. Would you be able to tell me why this is happening?

 

[Roger Carlson]

Now without more information. Where is the error happening? You may need
to set a breakpoint and step through the code to find it.

Also, I suggest you start another thread for this new question, it will help
people searching the newsgroups.


--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

I get the error: 3001, arguments are of the wrong type or out of acceptance
range or conflict with one another after I select combo2. The subform does
not find any records by selection when including combo2.