update Form and its subForm via two textboxes

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello and thanks in advance for your nice precious help.
I have a Form with just one subForm with a classic one to many relationship,
I am trying to filter the data of the whole Form from two text boxes. I
have seen ways of filtering via combobox but that is not what I want. I
would like to be able to filter the data with text as the search parameter.
The Form I open contains contacts that I would like to be able to filter
typing the initials in the mentioned textboxes for example typing "s" in
txtFirstName would then load the first record of the table starting with
FirstName with "s"

Sorry if I have probably repeated myself but I did it only to clarify that
I am not looking to filter the results in a listbox but on the records of
the main form itself.

Thank you,
Lorenzo


.

Relevant Pages

  • Re: search by last name in Select Users, Computers, Groups dialog?
    ... Under advanced tab in Search dialog box, you may select the "Last Name" option to filter only the last name that you want. ... By default Display Name and Logon Name fields are of ... for users by typing only their first name and not by typing their last ...
    (microsoft.public.windows.server.active_directory)
  • Re: So is Delphi 2007 the best ever?
    ... Peter Morris a écrit: ... Start typing the name of the component you want ... The component palette will filter down until you only have the one component you want. ...
    (borland.public.delphi.non-technical)
  • Re: Filter for ARIMA
    ... Any function that has no mcode available by typing:  edit filter ...
    (comp.soft-sys.matlab)
  • Re: Ping Nick Hodges
    ... Typing something like "query", that kind of filter shows me every ... searching for a *TSQLQuery", ...
    (borland.public.delphi.non-technical)
  • RE: Child control is changing data on exit, how to stop?
    ... The subform has Office Name as the link child and master fields. ... Does not position the form to the selected doctor? ... what else do I have to add to get this cbo to filter the subform ... The net effect is the bound control only changes when the record changes, ...
    (microsoft.public.access.forms)