Form Sort

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi,
I am using a form to input and browse records in a table of members
of a club. The first visible field on the form is "MemberID" and my question
is:

1)Can I have the field automatically display corresponding records as I type
in characters. e.g if I type in an "A" in the first cursor position for it
to display the first record starting with "A".If I type in a "B" subsequent
to the "A" for it to display the first record starting with "AB". Its a kind
of dynamic search.

Also can I have the tables automatically sorted by "memberID".
John
 
Hi John,

It's simplest to do this with a combo box to display the MemberId field.
Look for "Find a record by selecting a value from a list" in Help for
instructions.
 
Back
Top