Basing a combo box on another combo box - HELP!

[Guest]

I have got a categories table and products table. On my form I want to
select a category from my combo box that will look up all the products under
that category. Once I select the relevant product I want the information
about that product i.e. unit price, discount etc to also be looked up.

Has anyone any ideas of the best way to do this???

 

[Lynn Trapp]

Your comboboxes have a RowSource property. You can base your second combobox
on a query that uses the first combobox as a parameter value. Then, in the
Change event of the first combobox you requery the second one.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

Really sorry but I am not very expert on Access and don't really understand
what you have just told me. Is there a more simple way of explaining it? or
an example you can use? Thanks

 

[James McNellis]

Check out my post from last week (posted Aug. 5, 2005) entitled
Change ComboBox RecordSource on Continuous Forms

and the replies I got to it. They helped me out.

Just ignore that my form was a continuous form. That makes no difference.

HTH--

James.

 

[Lynn Trapp]

1. Open the property sheet for your first combobox and look for the
Rowsource property -- it will be on the data tab.
2. Click the button on the right end, it should have 3 dots on it, of that
property -- It will open up a query window where you can add the fields you
need.
3. Do the same for the second combobox, but make sure you reference the
first combobox is the criteria of the second query:
Forms!YourFormName!YourComboboxName.
4. Go back to the first combobox and look for the Change event. Click the
same button. When the dialog button opens select Code Builder. Add the
following code to the window that opens:

Forms!YourFormName!YourSecondComboboxName.Requery

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

Hi amigo JO..

here is the information that you need, I hope this help you!!

http://support.microsoft.com/default.aspx?scid=kb;en-us;209576


ldiaz

 

[wanghaixia]

Hi amigo JO..

here is the information that you need, I hope this help you!!

http://support.microsoft.com/default.aspx?scid=kb;en-us;209576


ldiaz