subform does not support set of events

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
 
N

niuginikiwi

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.
 
J

Jeanette Cunningham

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
 
M

Mark Kubicki

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top