J
Jon M.
Okay, I have a form based on a single table. I have two combo boxes that are
each one field from my table, one is office location and the other is
department. On this form I have a subform, which displays my table I'm
working from. This is soley a lookup form with no new data ever being
entered. When I select my office location and department nothing happens.
If I close the form and then reopen it I see the results I'm looking for.
How can I change this so that after selecting one combo box I get the results
right away I'm looking for? And then how can I make it so the user can use
either one or both of the boxes to get results based on just one box or both?
My ultimate goal would be for the user to select a choice from one or both
combo boxes and click a command button to retreive the desired records in the
subform. Sorry for writing a book here, but I'm lost. As always any help is
greatly appreciated.
each one field from my table, one is office location and the other is
department. On this form I have a subform, which displays my table I'm
working from. This is soley a lookup form with no new data ever being
entered. When I select my office location and department nothing happens.
If I close the form and then reopen it I see the results I'm looking for.
How can I change this so that after selecting one combo box I get the results
right away I'm looking for? And then how can I make it so the user can use
either one or both of the boxes to get results based on just one box or both?
My ultimate goal would be for the user to select a choice from one or both
combo boxes and click a command button to retreive the desired records in the
subform. Sorry for writing a book here, but I'm lost. As always any help is
greatly appreciated.