Option buttons

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thank you that work out. Know i have another question. The forms that has the
fields i mention before is name Search criteria Form, where i could search by
client id or Lastname. And i also have another form calle Search form where
all the clients are in. I would like for this two forms to interact. For
example

If i put in a client id and in the Search Critieria form and Click on the
Search commond button i added in, i would like it to take me to the Search
form where all the clients are at. I got it to work but it did not take me to
the EXACT client with the client ID i put in.

THe Search command button is linked to the search form which brings all the
clients. But i need it to look for the specific client i Put in in the Search
Criteria Form
 
Jessica:

One alternative is to use the Recordset objects FindFirst method to locate
the record you want on the Search form. For example:

Forms!MySearchForm.Recordset.FindFirst "ClientID=" &
Forms!MySearchCriteriaForm!txtClientID

This assumes you have the ClientID field in your Record Source for the
Search Form and that your textbox on the Search Criteria form is named
"txtClientID." You can use this code in the command button click event on
the Search Criteria form.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Thank you that work out. Know i have another question. The forms that has
the
fields i mention before is name Search criteria Form, where i could search
by
client id or Lastname. And i also have another form calle Search form where
all the clients are in. I would like for this two forms to interact. For
example

If i put in a client id and in the Search Critieria form and Click on the
Search commond button i added in, i would like it to take me to the Search
form where all the clients are at. I got it to work but it did not take me
to
the EXACT client with the client ID i put in.

THe Search command button is linked to the search form which brings all the
clients. But i need it to look for the specific client i Put in in the
Search
Criteria Form
 
Back
Top