I have extremely limited experience so please be gentle.
I have a maintenance database with over 6k records. I have a form for entering the individual tests. I have made this form a split form.
When I enter the Serial Number in the Main Form (left side) I want the Split Form(Right side) to only show those records that match that serial number.
I have attached a sample database showing the type of form I want to use.
If I enter a new test for Serial Number A568 for example, I want the 2 previous entries to be the only ones showing on the split form.
I expect it will involve an Event Procedure (on exit?) but I don't know how to filter the data properly.
Thanks
I have a maintenance database with over 6k records. I have a form for entering the individual tests. I have made this form a split form.
When I enter the Serial Number in the Main Form (left side) I want the Split Form(Right side) to only show those records that match that serial number.
I have attached a sample database showing the type of form I want to use.
If I enter a new test for Serial Number A568 for example, I want the 2 previous entries to be the only ones showing on the split form.
I expect it will involve an Event Procedure (on exit?) but I don't know how to filter the data properly.
Thanks