Searching for a record on a subform

[Amy E. Baggott]

I have a form that was designed (by someone else) to open from another form's
subform. They are so entwined that I cannot open the orders form except by
going to the search form and opening it from there. The search form consists
of a shell that sets the show ID and a few other parameters, with a subform
that lists the records that meet those parameters. There is a link on the
subform that opens the order based on the order ID for the record. However,
the OrderID field is not visible on the subform. I am trying to set up a
search dialog that will let you search and open orders by OrderID. So far, I
have set it up to open the main search form and set the focus to the subform.
However, I cannot set the focus to the OrderID on the subform because its
visibility is set to No. So how do I then get to the correct record to open
the Orders form? FindRecord requires that the focus be on the control you're
trying to match. Any ideas?

 

[Mark Andrews]

If you need to use FindRecord you can always make the field visible but so
small you can't see it
(it will look like a vertical line in design view). Don't make it a tabstop
either.

Also, perhaps try Allen Brownes site (he has lots of good info on normal
filtering techniques etc...), this article might help:
http://www.allenbrowne.com/ser-28.html

Mark
RPT Software
http://www.rptsoftware.com