Query and Combo Box

  • Thread starter Thread starter Michael Comtois
  • Start date Start date
M

Michael Comtois

Using Access 2002, how do I make it so that when I select
a value from a combo box, that value becomes the criteria
in the query, then it is requeried so that the next combo
box only has those values? Then it would have to be
reset when the next record is being added. Thanks for
any help!

Michael
 
In the After Update event of cbo1, you can set the rowsource of cbo2.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top