open form with same id number as previous form

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

Guest

I have a form with student info and from there i have a button which opens
another form with additional student info. I did this by making a parameter
query based on student id and every time i press that button i fill in the
student (whos info is on screen) id and then i get the additional info of
just that student. Is there any way of doing it more professional?
 
In your query design, where the criterion is currently something like
[Enter Student ID], change that to a reference to the form control, so
the query will "read" the student ID directly from the form. Assuming
the form name is frmStudentInfo and the control name is txtStudentID,
the syntax for your criterion should be:

Forms![frmStudentInf]![tctStudentID]

Just substitute the actual form and control names, and you are ready to go.

HTH,
Nikos
 
Thanks a million it works great. Amazing to see that anything you can think
of can really be done.

Nikos Yannacopoulos said:
In your query design, where the criterion is currently something like
[Enter Student ID], change that to a reference to the form control, so
the query will "read" the student ID directly from the form. Assuming
the form name is frmStudentInfo and the control name is txtStudentID,
the syntax for your criterion should be:

Forms![frmStudentInf]![tctStudentID]

Just substitute the actual form and control names, and you are ready to go.

HTH,
Nikos

Database said:
I have a form with student info and from there i have a button which opens
another form with additional student info. I did this by making a parameter
query based on student id and every time i press that button i fill in the
student (whos info is on screen) id and then i get the additional info of
just that student. Is there any way of doing it more professional?
Click to expand...
Click to expand...
 
Back
Top