Third Option of Combo Box Wizard (1 Viewer)

[kellan4459]

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]

Does anyone have a clue??? Please Help!

 

[Pat Hartman]

The form needs to be bound to a recordsource.

 

[kellan4459]

that did it thanks

 

[kellan4459]

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]

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]

Thanks ya'll that should take care of it. Makes perfect since!

Landon