Searching a form with a pop up search box

[DennisJones]

I have a form with lots of information on it and I need to add a couple of combo boxes to search for the next record to display on the form via different criteria (customer surname, or address or order no etc). My problem is that there isn't much room left on the screen to put the combo boxes. How can I create a sort of pop up message box (ie probably another form) on which the combo boxes are used following which the main form then automatically shows the required record?

thanks


Dennis

 

[missinglinq]

If I were doing it, I'd only use the single form, by doing this:

1. Place the comboboxes on the form
2. Set their Visibility property to No
3. Have a single "search" button that would set the Visibility of these comboboxes to True
4. In the AfterUpdate of each of the comboboxes, set the Visibility of all cbos to False

This would solve your real estate problem without having to go thru all the hassle of trying to use comboboxes on one form to retrieve records on another form.

Linq

 

[DennisJones]

Nice idea I am trying to put the combo boxes onto a rectangle that comes up when a search key is hit. The whole lot will then disappear after the search, the problem now is that when you use one of the combo boxes and it tries to make itself invisible you get an error saying that you can't make the focus invisible. Presumably I have to find a way to move the focus away from the box before making it invisible.

 

[missinglinq]

Sorry! Just set the focus to any other control on your form, then make the combobxes invisable.

 

[gemma-the-husky]

cant you just put a left arrow/right arrow icon next to the key fields on which you want to do this, and let the users click those. I can see someone wanting the next orderno, or next customer, but next address?