Hello,
I am designing a simple db and have created a main form (frmMenu) with a tab control with three pages. On each page, I have placed a different subform.
On page1, I have Subform1. This form gets its records from Table1 and has an unbound combo box that allows to move directly to the selected record.
What I would like to do is to open Page1 and view the SubForm1 blank without data. Users should select the record to view the entire recordset.
I would also like users to be able to modify or add data to this form but do not know what vba code to write down.
Can anyone help out with this? Appreciate your help.
I am designing a simple db and have created a main form (frmMenu) with a tab control with three pages. On each page, I have placed a different subform.
On page1, I have Subform1. This form gets its records from Table1 and has an unbound combo box that allows to move directly to the selected record.
What I would like to do is to open Page1 and view the SubForm1 blank without data. Users should select the record to view the entire recordset.
I would also like users to be able to modify or add data to this form but do not know what vba code to write down.
Can anyone help out with this? Appreciate your help.