combo box - requerying

[deekras]

i am creating an order form. the user selects (from combo boxes)the name of the show, (based on the show name)the show date, (based on the date) the seats. works fine for the first purchase, but if the same person purchases another show, when i try to select a date for the second show, it still gives me the info for the first show.

i guess i need to requery. i just don't know where or how to write the code.

 

[DML]

You can put a statment to requery the show dates combo box on the After update of the show names combo box. It will look something like this...

On After Update of the Show Names

me.ShowDatesCombobox.requery

I am assuming that you are using the value of the show names combo box as part of the criteria in the rowsource of the show dates combo box. Is this true?