Changing a row source

[DasT]

Hi all!

this one seems to have eluded me completely...

First off I have a form set up with two combo boxes and a table for each row source, one combo box which stays the same, however when the user makes a selection from the first combo box I want the functionality for the second combo box to change its row source, is this possible? if not is it possible via a button or something else?

Any help is appreciated

 

[texasalynn]

I think this will help you:

http://www.mrexcel.com/board2/viewtopic.php?t=75140

HTH
texasalynn

 

[DasT]

Thanks for the help, however I'm stuck again...

I need to be able to take the result from the selection in the combobox and use it as criteria in a query which can then create a report...

I'm currently trying to figure it out myself, but any mor ehelp would be greatly appreciated

Cheers!

 

[Cbrine]

1. Just open your form that the combobox exists in.
2. Open the query you want to assign criteria to.
3. RIght click on the criteria line under the field you want to filter on, and select build.
4. In the tree view, click on forms, loaded forms, your form and in the next box, double click on the combobox name.
5. Click on OK.
6. Save you query.

Your query, when run with the form open should now filter based on the combobox value.

HTH
Cal

 

[DasT]

Thanks, it works a treat now