subform does not support set of events

  • Thread starter Thread starter Mark Kubicki
  • Start date Start date
M

Mark Kubicki

I have on a form [frmSpec] a simple subform [fsubMfrAlts] with a data source
of a table [tblMfrAlt] whose fields are [Type] and [MfrAlt]
the subform is related to the parent table with the field [Type] (as entered
on the parent form in the control [txtType]

however, when I enter data into the subform, I get this error: "Object or
Class does not support the set of events"
if I 'OK' the error I am then am able to enter data into the [MfrAlt] field;
however,the [Type] field in the table [tblMfrAlt] does fill in with the
[txtType] data entry on the parent form


bewildered and confused
but thanking you in advance
mark
 
You may want to check your object References

To do that, in the VBA editor, go to Tools and then References and makes
sure MS Access 12.0 Object Library, MS DOA 3.6 Object Library and other
required references are selected.
 
Hi Mark,
most likely the error is due to the way the record sources for the main form
and the subform are setup.
Post back with details of the query / table for each form.
Include names of primary keys and foreign keys and the relationships between
the tables used for the 2 forms.



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
you were right (thanks...) there was a mis-alignment of the primary keys ...

-mark

Jeanette Cunningham said:
Hi Mark,
most likely the error is due to the way the record sources for the main
form and the subform are setup.
Post back with details of the query / table for each form.
Include names of primary keys and foreign keys and the relationships
between the tables used for the 2 forms.



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia



Mark Kubicki said:
I have on a form [frmSpec] a simple subform [fsubMfrAlts] with a data
source of a table [tblMfrAlt] whose fields are [Type] and [MfrAlt]
the subform is related to the parent table with the field [Type] (as
entered on the parent form in the control [txtType]

however, when I enter data into the subform, I get this error: "Object or
Class does not support the set of events"
if I 'OK' the error I am then am able to enter data into the [MfrAlt]
field; however,the [Type] field in the table [tblMfrAlt] does fill in
with the [txtType] data entry on the parent form


bewildered and confused
but thanking you in advance
mark
Click to expand...
Click to expand...
 
Back
Top