Form/SubForm error while reference the object

  • Thread starter Thread starter CarolD
  • Start date Start date
C

CarolD

I am a novice at Access and do not understand the VB codes.
I have created a form (Software Register) with a subform (Licence No). I
have created a one to many relationship between Software_ID_No in both forms.
The Link Child and Link Master fields are populated with Software_ID_No.
My subform (Licence No) now is linked to the main form (software Register)
and moves with that form.
What I want to do is have the Software_ID_No in the main form populate the
Software_ID_No in the subform, and also put it into the Licence No Table. If
I enter the number manually, it works.
When I click on the + in the Licence No table, I get the error message:
"An error occurred while referencing the object. You tried to run a Visual
Basci procedure that improperly references a property or method of an object."
I also get that error on the first entry in the Licence No subform.
If you can help, can you do it step by step please?
 
When you want to add a new record in the subform, the Software_ID_No in the
subform will be blank until you enter some other data in another control in
the subform. Then the Software_ID_No in the subform will auto populate with
the same value as Software_ID_No in the main form.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Back
Top