LinkMasterFields Error

[Stacey Crowhurst]

Hi. I have a form with a subform. On the form is the following:
Trans ID - Autonumber
Date Entered
CCP No
Check No
Check Date
Status
Source

On the subform is the following:
Trans Detail ID - Autonumber
Trans ID - links to Trans ID from above
Contract
Invoice No
Invoice Date
Vendor ID
Cost Code
Line Amount

The form records transaction details. Sometimes one check will pay for
mutiple invoices so that is the basis for the parent/child relationship.
Anyway, when using my form I get the following error when I start entering
data in the subform.

The LinkMasterFields property setting has produced this error: 'Object or
class does not support the set of events'

I just click ok and it lets me go on my merry way and input all my data.
However, it is annoying and I would like to fix it so the error does not
occur. Any ideas?

Thanks.

 

[Jeanette Cunningham]

Hi Stacey,
try this:
Delete the LinkMasterFields and LinkChildFields
Save the form.
Backup the databaase, do a compact and repair.
Go back into the form and setup the LinkMasterFields and LinkChildFields.

The form might be showing the start of corruption.
For help on corruption you might wish to check this link
http://allenbrowne.com/ser-47.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Stacey Crowhurst]

Jeanette, where do I go to delete the master/child fields?

 

[Jeanette Cunningham]

Open the form in design view.
Click once on the subform - you should be able to see the handles around
its border.
Open the properties dialog for the form if it's not already open.
On the Data Tab, you will see the master/child fields.
Clear the entries for these 2 properties.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[John W. Vinson]

Jeanette, where do I go to delete the master/child fields?

View the Properties of the Subform Control (the box containing the form, not
the form within that box).

 

[Stacey Crowhurst]

Ok, I found the master/child properties and deleted them. Then I
compacted/repaired and then reinput Trans ID as the master/child properties.
But the form still gives me the error. Any other ideas? Should I recreate
the form from scratch?

 

[Jeanette Cunningham]

Would you post back with the contents of the master/child fields.
What version of access?
You can do a quickie test form and subform using the form wizard. If the
quickie works without the error message, then you know it is a problem with
the original form.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Stacey Crowhurst]

Thanks Jeanette. It's MS Access 2003 SP3.

I'm not sure what you want for contents so I'll err on the side of too much
information.

Transactions - General = Master Form
Trans ID = 1
CCP No = RAC04-01
Date Entered = 03/03/2009
Status = P
Check No = 222111
Check Date = 02/18/2009
Source = PO

Transactions - Detail = Child Form
Trans Detail ID = 1
Trans ID = 1
Invoice No = 337
Invoice Date = 01/31/2009
Vendor ID = 0000001526
Contract = 450
Cost Cost = 450_6126
Line Amount = $2,420
----
Trans Detail ID = 2
Trans ID = 1
Invoice No = 337
Invoice Date = 01/31/2009
Vendor ID = 0000001526
Contract = 450
Cost Cost = 450_6127
Line Amount = $58.65
----
Trans Detail ID = 3
Trans ID = 1
Invoice No = 389
Invoice Date = 02/08/2009
Vendor ID = 0000001526
Contract = 450
Cost Cost = 450_6126
Line Amount = $1,500

So basically check number 222111 paid two invoices (337, 389). And inovoice
337 was split between two cost codes.

Let me know if you need more info. Thanks again.

 

[Jeanette Cunningham]

I meant when you open the form in design view, click on the subform control
once, on the property dialog go to the data tab and postback with the
contents of the link master field and the link child field.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Stacey Crowhurst]

Ok (thanks for your patience!)

Link Child Fields = Trans ID
Link Master Fields = Trans ID

 

[Jeanette Cunningham]

I notice that there is a space between words in many of your field names.
Access has a problem with spaces in table field names ( it gets confused ) -
so instead of Trans ID, try it with square brackets.
[Trans ID] for both master/child fields.

Here is a tip:
You can save yourself a lot of typing of square brackets if you change
things so that the tables have field names without spaces.
If you decide to do this, make sure you have a working backup copy of the
current database before you change the field names.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Stacey Crowhurst]

Thanks Jeanette. I tried [Trans ID] and it still shows the error message. I
suppose there isn't an easy way to update all of my names to remove spaces
and non alpha characters?

I notice that there is a space between words in many of your field names.
Access has a problem with spaces in table field names ( it gets confused ) -
so instead of Trans ID, try it with square brackets.
[Trans ID] for both master/child fields.

Here is a tip:
You can save yourself a lot of typing of square brackets if you change
things so that the tables have field names without spaces.
If you decide to do this, make sure you have a working backup copy of the
current database before you change the field names.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Ok (thanks for your patience!)

Link Child Fields = Trans ID
Link Master Fields = Trans ID

 

[Jeanette Cunningham]

Not sure why adding square brackets didn't fix the problem.
I would try a quickie test form and subform made by the wizard before going
to the trouble of changing field names.

To change the field names to remove spaces, the easiest way I know is to use
a software utility specially made to do this - if you have a lot of queries
and forms.
If you only have a few forms and a few queries, you could it manually.
I use one by Rick Fisher called Find and Replace. There are also FMS, Inc.
(Total Access Analyzer), Black Moshanon (Speed Ferrett).

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Thanks Jeanette. I tried [Trans ID] and it still shows the error message.
I
suppose there isn't an easy way to update all of my names to remove spaces
and non alpha characters?

I notice that there is a space between words in many of your field names.
Access has a problem with spaces in table field names ( it gets
confused ) -
so instead of Trans ID, try it with square brackets.
[Trans ID] for both master/child fields.

Here is a tip:
You can save yourself a lot of typing of square brackets if you change
things so that the tables have field names without spaces.
If you decide to do this, make sure you have a working backup copy of the
current database before you change the field names.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Ok (thanks for your patience!)

Link Child Fields = Trans ID
Link Master Fields = Trans ID

:

I meant when you open the form in design view, click on the subform
control
once, on the property dialog go to the data tab and postback with the
contents of the link master field and the link child field.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

in
message Thanks Jeanette. It's MS Access 2003 SP3.

I'm not sure what you want for contents so I'll err on the side of
too
much
information.

Transactions - General = Master Form
Trans ID = 1
CCP No = RAC04-01
Date Entered = 03/03/2009
Status = P
Check No = 222111
Check Date = 02/18/2009
Source = PO

Transactions - Detail = Child Form
Trans Detail ID = 1
Trans ID = 1
Invoice No = 337
Invoice Date = 01/31/2009
Vendor ID = 0000001526
Contract = 450
Cost Cost = 450_6126
Line Amount = $2,420
----
Trans Detail ID = 2
Trans ID = 1
Invoice No = 337
Invoice Date = 01/31/2009
Vendor ID = 0000001526
Contract = 450
Cost Cost = 450_6127
Line Amount = $58.65
----
Trans Detail ID = 3
Trans ID = 1
Invoice No = 389
Invoice Date = 02/08/2009
Vendor ID = 0000001526
Contract = 450
Cost Cost = 450_6126
Line Amount = $1,500

So basically check number 222111 paid two invoices (337, 389). And
inovoice
337 was split between two cost codes.

Let me know if you need more info. Thanks again.

:

Would you post back with the contents of the master/child fields.
What version of access?
You can do a quickie test form and subform using the form wizard.
If
the
quickie works without the error message, then you know it is a
problem
with
the original form.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Stacey Crowhurst" <[email protected]>
wrote
in
message Ok, I found the master/child properties and deleted them. Then I
compacted/repaired and then reinput Trans ID as the master/child
properties.
But the form still gives me the error. Any other ideas? Should
I
recreate
the form from scratch?

:

Open the form in design view.
Click once on the subform - you should be able to see the
handles
around
its border.
Open the properties dialog for the form if it's not already
open.
On the Data Tab, you will see the master/child fields.
Clear the entries for these 2 properties.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria
Australia


"Stacey Crowhurst" <[email protected]>
wrote
in
message
Jeanette, where do I go to delete the master/child fields?

:

Hi Stacey,
try this:
Delete the LinkMasterFields and LinkChildFields
Save the form.
Backup the databaase, do a compact and repair.
Go back into the form and setup the LinkMasterFields and
LinkChildFields.

The form might be showing the start of corruption.
For help on corruption you might wish to check this link
http://allenbrowne.com/ser-47.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria
Australia


"Stacey Crowhurst"
<[email protected]>
wrote
in
message
Hi. I have a form with a subform. On the form is the
following:
Trans ID - Autonumber
Date Entered
CCP No
Check No
Check Date
Status
Source

On the subform is the following:
Trans Detail ID - Autonumber
Trans ID - links to Trans ID from above
Contract
Invoice No
Invoice Date
Vendor ID
Cost Code
Line Amount

The form records transaction details. Sometimes one check
will
pay
for
mutiple invoices so that is the basis for the parent/child
relationship.
Anyway, when using my form I get the following error when I
start
entering
data in the subform.

The LinkMasterFields property setting has produced this
error:
'Object
or
class does not support the set of events'

I just click ok and it lets me go on my merry way and input
all
my
data.
However, it is annoying and I would like to fix it so the
error
does
not
occur. Any ideas?

Thanks.

 

[Ken Snell MVP]

Some less likely reasons for the error message (Jeanette has addressed the
more likely ones).

Is Trans ID the name of a field in the form's RecordSource? And also the
name of the control that is bound to that field? If yes, ACCESS may become
confused over which "one" to use.

It's also possible that this is a timing issue with the form and subform if
the main form is not quite done saving its record before you start entering
data into the subform.

Do you get the error as soon as you click into a field in the subform? Or
when you tab into the subform? Can you isolate the "exact" action that
causes the error to show up? Do you see this only when there are no records
in the subform, or do you see it both when there are no records or when
there is at least one record in the subform?
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

Thanks Jeanette. I tried [Trans ID] and it still shows the error message.
I
suppose there isn't an easy way to update all of my names to remove spaces
and non alpha characters?

I notice that there is a space between words in many of your field names.
Access has a problem with spaces in table field names ( it gets
confused ) -
so instead of Trans ID, try it with square brackets.
[Trans ID] for both master/child fields.

Here is a tip:
You can save yourself a lot of typing of square brackets if you change
things so that the tables have field names without spaces.
If you decide to do this, make sure you have a working backup copy of the
current database before you change the field names.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Ok (thanks for your patience!)

Link Child Fields = Trans ID
Link Master Fields = Trans ID

:

I meant when you open the form in design view, click on the subform
control
once, on the property dialog go to the data tab and postback with the
contents of the link master field and the link child field.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

in
message Thanks Jeanette. It's MS Access 2003 SP3.

I'm not sure what you want for contents so I'll err on the side of
too
much
information.

Transactions - General = Master Form
Trans ID = 1
CCP No = RAC04-01
Date Entered = 03/03/2009
Status = P
Check No = 222111
Check Date = 02/18/2009
Source = PO

Transactions - Detail = Child Form
Trans Detail ID = 1
Trans ID = 1
Invoice No = 337
Invoice Date = 01/31/2009
Vendor ID = 0000001526
Contract = 450
Cost Cost = 450_6126
Line Amount = $2,420
----
Trans Detail ID = 2
Trans ID = 1
Invoice No = 337
Invoice Date = 01/31/2009
Vendor ID = 0000001526
Contract = 450
Cost Cost = 450_6127
Line Amount = $58.65
----
Trans Detail ID = 3
Trans ID = 1
Invoice No = 389
Invoice Date = 02/08/2009
Vendor ID = 0000001526
Contract = 450
Cost Cost = 450_6126
Line Amount = $1,500

So basically check number 222111 paid two invoices (337, 389). And
inovoice
337 was split between two cost codes.

Let me know if you need more info. Thanks again.

:

Would you post back with the contents of the master/child fields.
What version of access?
You can do a quickie test form and subform using the form wizard.
If
the
quickie works without the error message, then you know it is a
problem
with
the original form.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Stacey Crowhurst" <[email protected]>
wrote
in
message Ok, I found the master/child properties and deleted them. Then I
compacted/repaired and then reinput Trans ID as the master/child
properties.
But the form still gives me the error. Any other ideas? Should
I
recreate
the form from scratch?

:

Open the form in design view.
Click once on the subform - you should be able to see the
handles
around
its border.
Open the properties dialog for the form if it's not already
open.
On the Data Tab, you will see the master/child fields.
Clear the entries for these 2 properties.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria
Australia


"Stacey Crowhurst" <[email protected]>
wrote
in
message
Jeanette, where do I go to delete the master/child fields?

:

Hi Stacey,
try this:
Delete the LinkMasterFields and LinkChildFields
Save the form.
Backup the databaase, do a compact and repair.
Go back into the form and setup the LinkMasterFields and
LinkChildFields.

The form might be showing the start of corruption.
For help on corruption you might wish to check this link
http://allenbrowne.com/ser-47.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria
Australia


"Stacey Crowhurst"
<[email protected]>
wrote
in
message
Hi. I have a form with a subform. On the form is the
following:
Trans ID - Autonumber
Date Entered
CCP No
Check No
Check Date
Status
Source

On the subform is the following:
Trans Detail ID - Autonumber
Trans ID - links to Trans ID from above
Contract
Invoice No
Invoice Date
Vendor ID
Cost Code
Line Amount

The form records transaction details. Sometimes one check
will
pay
for
mutiple invoices so that is the basis for the parent/child
relationship.
Anyway, when using my form I get the following error when I
start
entering
data in the subform.

The LinkMasterFields property setting has produced this
error:
'Object
or
class does not support the set of events'

I just click ok and it lets me go on my merry way and input
all
my
data.
However, it is annoying and I would like to fix it so the
error
does
not
occur. Any ideas?

Thanks.

 

[Stacey Crowhurst]

Hi Ken.
For error timing, it is consistent. It pops up with the error after I type
my first character of data in the subform. Then it will give me the error
again if save the suform record by either hitting next line or clicking back
to the main form. Then after that it will give me the error if I click
between the main and sub forms.

And yes, [Trans ID] is a field from the form's record source. It is also
one of the fields shown in the form. It is an autonumber field. Let me know
if you need more information. Thanks.

Some less likely reasons for the error message (Jeanette has addressed the
more likely ones).

Is Trans ID the name of a field in the form's RecordSource? And also the
name of the control that is bound to that field? If yes, ACCESS may become
confused over which "one" to use.

It's also possible that this is a timing issue with the form and subform if
the main form is not quite done saving its record before you start entering
data into the subform.

Do you get the error as soon as you click into a field in the subform? Or
when you tab into the subform? Can you isolate the "exact" action that
causes the error to show up? Do you see this only when there are no records
in the subform, or do you see it both when there are no records or when
there is at least one record in the subform?
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

Thanks Jeanette. I tried [Trans ID] and it still shows the error message.
I
suppose there isn't an easy way to update all of my names to remove spaces
and non alpha characters?

I notice that there is a space between words in many of your field names.
Access has a problem with spaces in table field names ( it gets
confused ) -
so instead of Trans ID, try it with square brackets.
[Trans ID] for both master/child fields.

Here is a tip:
You can save yourself a lot of typing of square brackets if you change
things so that the tables have field names without spaces.
If you decide to do this, make sure you have a working backup copy of the
current database before you change the field names.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


message Ok (thanks for your patience!)

Link Child Fields = Trans ID
Link Master Fields = Trans ID

:

I meant when you open the form in design view, click on the subform
control
once, on the property dialog go to the data tab and postback with the
contents of the link master field and the link child field.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

in
message Thanks Jeanette. It's MS Access 2003 SP3.

I'm not sure what you want for contents so I'll err on the side of
too
much
information.

Transactions - General = Master Form
Trans ID = 1
CCP No = RAC04-01
Date Entered = 03/03/2009
Status = P
Check No = 222111
Check Date = 02/18/2009
Source = PO

Transactions - Detail = Child Form
Trans Detail ID = 1
Trans ID = 1
Invoice No = 337
Invoice Date = 01/31/2009
Vendor ID = 0000001526
Contract = 450
Cost Cost = 450_6126
Line Amount = $2,420
----
Trans Detail ID = 2
Trans ID = 1
Invoice No = 337
Invoice Date = 01/31/2009
Vendor ID = 0000001526
Contract = 450
Cost Cost = 450_6127
Line Amount = $58.65
----
Trans Detail ID = 3
Trans ID = 1
Invoice No = 389
Invoice Date = 02/08/2009
Vendor ID = 0000001526
Contract = 450
Cost Cost = 450_6126
Line Amount = $1,500

So basically check number 222111 paid two invoices (337, 389). And
inovoice
337 was split between two cost codes.

Let me know if you need more info. Thanks again.

:

Would you post back with the contents of the master/child fields.
What version of access?
You can do a quickie test form and subform using the form wizard.
If
the
quickie works without the error message, then you know it is a
problem
with
the original form.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Stacey Crowhurst" <[email protected]>
wrote
in
message Ok, I found the master/child properties and deleted them. Then I
compacted/repaired and then reinput Trans ID as the master/child
properties.
But the form still gives me the error. Any other ideas? Should
I
recreate
the form from scratch?

:

Open the form in design view.
Click once on the subform - you should be able to see the
handles
around
its border.
Open the properties dialog for the form if it's not already
open.
On the Data Tab, you will see the master/child fields.
Clear the entries for these 2 properties.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria
Australia


"Stacey Crowhurst" <[email protected]>
wrote
in
message
Jeanette, where do I go to delete the master/child fields?

:

Hi Stacey,
try this:
Delete the LinkMasterFields and LinkChildFields
Save the form.
Backup the databaase, do a compact and repair.
Go back into the form and setup the LinkMasterFields and
LinkChildFields.

The form might be showing the start of corruption.
For help on corruption you might wish to check this link
http://allenbrowne.com/ser-47.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria
Australia


"Stacey Crowhurst"
<[email protected]>
wrote
in
message
Hi. I have a form with a subform. On the form is the
following:
Trans ID - Autonumber
Date Entered
CCP No
Check No
Check Date
Status
Source

On the subform is the following:
Trans Detail ID - Autonumber
Trans ID - links to Trans ID from above
Contract
Invoice No
Invoice Date
Vendor ID
Cost Code
Line Amount

The form records transaction details. Sometimes one check
will
pay
for
mutiple invoices so that is the basis for the parent/child
relationship.
Anyway, when using my form I get the following error when I
start
entering
data in the subform.

The LinkMasterFields property setting has produced this
error:
'Object
or
class does not support the set of events'

I just click ok and it lets me go on my merry way and input
all
my
data.
However, it is annoying and I would like to fix it so the
error
does
not
occur. Any ideas?

Thanks.

 

[Stacey Crowhurst]

Jeanette, I did the quickie test with the wizard and I don't get the error.
I'm just going to go ahead and recreate the form. Thanks for your help.
Stacey

Not sure why adding square brackets didn't fix the problem.
I would try a quickie test form and subform made by the wizard before going
to the trouble of changing field names.

To change the field names to remove spaces, the easiest way I know is to use
a software utility specially made to do this - if you have a lot of queries
and forms.
If you only have a few forms and a few queries, you could it manually.
I use one by Rick Fisher called Find and Replace. There are also FMS, Inc.
(Total Access Analyzer), Black Moshanon (Speed Ferrett).

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Thanks Jeanette. I tried [Trans ID] and it still shows the error message.
I
suppose there isn't an easy way to update all of my names to remove spaces
and non alpha characters?

I notice that there is a space between words in many of your field names.
Access has a problem with spaces in table field names ( it gets
confused ) -
so instead of Trans ID, try it with square brackets.
[Trans ID] for both master/child fields.

Here is a tip:
You can save yourself a lot of typing of square brackets if you change
things so that the tables have field names without spaces.
If you decide to do this, make sure you have a working backup copy of the
current database before you change the field names.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


message Ok (thanks for your patience!)

Link Child Fields = Trans ID
Link Master Fields = Trans ID

:

I meant when you open the form in design view, click on the subform
control
once, on the property dialog go to the data tab and postback with the
contents of the link master field and the link child field.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

in
message Thanks Jeanette. It's MS Access 2003 SP3.

I'm not sure what you want for contents so I'll err on the side of
too
much
information.

Transactions - General = Master Form
Trans ID = 1
CCP No = RAC04-01
Date Entered = 03/03/2009
Status = P
Check No = 222111
Check Date = 02/18/2009
Source = PO

Transactions - Detail = Child Form
Trans Detail ID = 1
Trans ID = 1
Invoice No = 337
Invoice Date = 01/31/2009
Vendor ID = 0000001526
Contract = 450
Cost Cost = 450_6126
Line Amount = $2,420
----
Trans Detail ID = 2
Trans ID = 1
Invoice No = 337
Invoice Date = 01/31/2009
Vendor ID = 0000001526
Contract = 450
Cost Cost = 450_6127
Line Amount = $58.65
----
Trans Detail ID = 3
Trans ID = 1
Invoice No = 389
Invoice Date = 02/08/2009
Vendor ID = 0000001526
Contract = 450
Cost Cost = 450_6126
Line Amount = $1,500

So basically check number 222111 paid two invoices (337, 389). And
inovoice
337 was split between two cost codes.

Let me know if you need more info. Thanks again.

:

Would you post back with the contents of the master/child fields.
What version of access?
You can do a quickie test form and subform using the form wizard.
If
the
quickie works without the error message, then you know it is a
problem
with
the original form.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Stacey Crowhurst" <[email protected]>
wrote
in
message Ok, I found the master/child properties and deleted them. Then I
compacted/repaired and then reinput Trans ID as the master/child
properties.
But the form still gives me the error. Any other ideas? Should
I
recreate
the form from scratch?

:

Open the form in design view.
Click once on the subform - you should be able to see the
handles
around
its border.
Open the properties dialog for the form if it's not already
open.
On the Data Tab, you will see the master/child fields.
Clear the entries for these 2 properties.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria
Australia


"Stacey Crowhurst" <[email protected]>
wrote
in
message
Jeanette, where do I go to delete the master/child fields?

:

Hi Stacey,
try this:
Delete the LinkMasterFields and LinkChildFields
Save the form.
Backup the databaase, do a compact and repair.
Go back into the form and setup the LinkMasterFields and
LinkChildFields.

The form might be showing the start of corruption.
For help on corruption you might wish to check this link
http://allenbrowne.com/ser-47.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria
Australia


"Stacey Crowhurst"
<[email protected]>
wrote
in
message
Hi. I have a form with a subform. On the form is the
following:
Trans ID - Autonumber
Date Entered
CCP No
Check No
Check Date
Status
Source

On the subform is the following:
Trans Detail ID - Autonumber
Trans ID - links to Trans ID from above
Contract
Invoice No
Invoice Date
Vendor ID
Cost Code
Line Amount

The form records transaction details. Sometimes one check
will
pay
for
mutiple invoices so that is the basis for the parent/child
relationship.
Anyway, when using my form I get the following error when I
start
entering
data in the subform.

The LinkMasterFields property setting has produced this
error:
'Object
or
class does not support the set of events'

I just click ok and it lets me go on my merry way and input
all
my
data.
However, it is annoying and I would like to fix it so the
error
does
not
occur. Any ideas?

Thanks.

 

[Ken Snell MVP]

I don't know that this would make a difference, but rename the control that
is bound to the TransID field to a different name -- say, txtTransID. Then
use the txtTransID name in the LinkMasterFields property for the subform
control.