Open a Specified Record

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

Guest

I have a database where data is entered for student's disclipline records. I
want to be able to have a user enter a student's ID on the main form in a
text box, called txtstudentID. Then have the user click a Search button that
will then open a continuous form and display all records with with the
specified student number. For instance, if I enter 10101, it will pull all
records in te continuous form for the student with the ID of 10101. All
relevant data is stored in a single database.
How could I do this?
 
One way would be to set the filter property of the
RecordSource in the OnOpen event VBA code. You
can pass the ID to the form that displays all records
for the given individual.

It would also seem important here that the ID field
in the underlying query be the "key" field.

This should at least help to get you started.

Bill
 
Back
Top