View Full Version : Third Option of Combo Box Wizard


kellan4459
12-05-2001, 09:22 AM
What Reference has to be turned on in order to get the third option of get data based on selection? I can't seem to find the correct Reference!
Thanks
Landon

kellan4459
12-06-2001, 04:10 AM
Does anyone have a clue??? Please Help!

Pat Hartman
12-06-2001, 05:11 AM
The form needs to be bound to a recordsource.

kellan4459
12-06-2001, 05:18 AM
that did it thanks

kellan4459
12-06-2001, 05:32 AM
If I have a table Called Submittal ID
which consists of ID, Component, Award Date
and a second Table
which consists of Area, Area Description
and I want to have two combo boxes one to select submittal ID and with that selection update the second to choose area associated with the submittal.
After these two selections I want a list box to pull from a table called ReqMaterial
to display everything associated with the two selections how would this be done. The wizard only links to the one table

Jack Cowley
12-06-2001, 05:47 AM
This should get you started...

http://support.microsoft.com/support/kb/articles/Q209/5/76.ASP?LN=EN-US&SD=gn&FR=0&qry=q209576&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

kellan4459
12-06-2001, 05:53 AM
Thanks ya'll that should take care of it. Makes perfect since!

Landon