aaabuhalime
Instructor
Hi,
I have created a navigation form for students information the form created from a query (record source) is a query, each page contains different form, student Id and class both are auto populated among the pages/forms, in one of the pages I include command buttons to add new information, this button should open the first form/page to enter new information, but what I am getting is the match record for the student populated /displayed in the main page/form, when i remove the condition
StudentID=Forms!formSS!StudentID, the form will display the first record in the query where all the records coming from, my question is how can I make the form blank, so when I click the button it opens the first form where it is ready for new data entry with keeping the student ID and class auto populated, so when I open the form all what included is the Student Id and Class the rest is blank for new data entry .
Any help will be appreciated,
I have created a navigation form for students information the form created from a query (record source) is a query, each page contains different form, student Id and class both are auto populated among the pages/forms, in one of the pages I include command buttons to add new information, this button should open the first form/page to enter new information, but what I am getting is the match record for the student populated /displayed in the main page/form, when i remove the condition
StudentID=Forms!formSS!StudentID, the form will display the first record in the query where all the records coming from, my question is how can I make the form blank, so when I click the button it opens the first form where it is ready for new data entry with keeping the student ID and class auto populated, so when I open the form all what included is the Student Id and Class the rest is blank for new data entry .
Any help will be appreciated,
