Hello,
I am developing a master/detail form to update QA data for Shop Orders in ERP system.
Primary Key to the shop order header file is Shop Orders #
Primary key to the Shop Order detail file is Shop order # and Line No.
The form can only be open in Edit Mode and users are not allowed to add or delete records in the form.
I have added a combo box on the form to "Find a record on my form based on the value I selected in my combo box" . combo box is created on shop order header table and is filtering based on Shop order No.
When the form is open it loads the first record from the table. Subsequently when I select the Shop order # from the combo box it locates respective shop order # for the users to edit and this functionality is good to go.
My Issues is when the form loads the first time, it should not default to the first record in the table but provide the user with a blank form and when the user selects the shop order # from combo box it loads the respective record for user to edit.
How can this be achieved.? as mentioned users are not allowed to add new records in the form.
Please advise.
Vincent