Hello,
Can't get this to work, hopefully someone can give me a hand here.
I have combo box on my form that loads some data into a subform. I may have to edit that data, so I put a command button next to the combo box that launches a form that I can use to edit the data with. So far so good.
My problem is that I would like the form to load the current record. All I seem to be able to do though is either start a blank form that creates a new record, or start the form with the first record in the table.
I tried to have the pop-up form read the Id of the record that's selected in the combo box, but I get a runtime error - can't assign a value to this object.
Private Sub Form_Load()
Me.ComSupID = Forms!frmRSC.ComSupID
Can't get this to work, hopefully someone can give me a hand here.
I have combo box on my form that loads some data into a subform. I may have to edit that data, so I put a command button next to the combo box that launches a form that I can use to edit the data with. So far so good.
My problem is that I would like the form to load the current record. All I seem to be able to do though is either start a blank form that creates a new record, or start the form with the first record in the table.
I tried to have the pop-up form read the Id of the record that's selected in the combo box, but I get a runtime error - can't assign a value to this object.
Private Sub Form_Load()
Me.ComSupID = Forms!frmRSC.ComSupID