J
Jeff
I have a form with the following:
txtbox numStudentRef
txtbox txtName
Tab Control [Information]
On each tab control is a subform control for each tab page.
On the form in the first tab page subform control are personal details
and an autonumber Student Ref;
When a user inputs infor the autonumber is shown, perfect. but the
numStudentRef on the mainform remains blank.
This means that the other subforms in the other subform controls on the
other tab controls don't have anything to reference yet and they don't
filter.
I put a requery on a button on the mainform, and then all the subforms
can show the same filtered record, but when it requeries, it always goes
back to the first record.
How can I get the button to requery the mainform and maintain the
present record?
Any ideas greatly appreciated,
Jeff
txtbox numStudentRef
txtbox txtName
Tab Control [Information]
On each tab control is a subform control for each tab page.
On the form in the first tab page subform control are personal details
and an autonumber Student Ref;
When a user inputs infor the autonumber is shown, perfect. but the
numStudentRef on the mainform remains blank.
This means that the other subforms in the other subform controls on the
other tab controls don't have anything to reference yet and they don't
filter.
I put a requery on a button on the mainform, and then all the subforms
can show the same filtered record, but when it requeries, it always goes
back to the first record.
How can I get the button to requery the mainform and maintain the
present record?
Any ideas greatly appreciated,
Jeff