Re: Using DoCmd.FindRecord -
03-10-2008
, 02:03 PM
Hi Ben,
I am guessing that [yCustomer Search Dialog] is your modal search form.
How are you populating the textbox on this form? I am guessing that [By
Search Type] is a textbox on the the form.
Try this: first - remember that a form is just a class, and as such you
can use Class properties Get/Set/Let within the form.
Add a Get Property to your main form
Public Property Get SearchCriteria() As String
SearchCriteria = "something"
End Property
then in the modal form you can read it liket this:
strSearch = Forms(MainFrom).SearchCriteria
You can also set Class properties in your search form and read the
values that you set in the search form public property Get in the same
way. Maybe that might improve performance for you.
HTH,
Rich
*** Sent via Developersdex http://www.developersdex.com *** |