Error occured while referecing an object?

D

Don

I am dumbfounded why I get this error, becaue I have
designed databases before.

I have what seems to be three simple tables...
tblApplications
Application (PK)

tblTechnicians
Name (PK)

tblEscalation
Application (DualPK)
Name (DualPK) ( A combo box from tblTechnicians)
Notes (Memo Field)

my form/subform has Application from the tblApplications
tables and the subform has Name and Notes from the
tblEscalation table.

I have a one to many link for Application, and have
created a form with a subform linking Applications between
tblApplications and tblEscalation (one Application can be
escalated to many people, but not the same person twice of
course)

Whenever I try to enter records into my subform I receive
an error that says "Error occured while referecing an
object. You tried to run a visual basic procedure that
improperly references a property or method of an object."

I thought I had my dual PK set up properly.

Any ideas why I might be getting this?

Thanks in advance for any ideas.

Don
 
D

Duane Hookom

Quite possibly your issue is your choice (or someone else's) of Name as the
name of a field. Every object in Access has a name property so using Name as
the property name of a name field isn't wise.
 

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