linked tables and forms

C

Chris

Hello everybody,

I've been staring at this problem for six hours straight
now without making any headway, so ANY clue as to what
might be causing this is immensely appreciated.

I have two tables, Patients and Admissions, which are
linked in a 1 <-> Many relationship with referential
integrity. I also have a corresponding form and respective
subform where the link master and child fields are set to
the single unique identifier.

The problem now is that when I go to a new record on the
master form (either using DoCmd.GoToRecord , , acNewRecord
or record navigation buttons) and try to enter the primary
key, I get the error message "You cannot add or change a
record because a related record is required in table
'Admissions'".

This error did not appear when i started making the
database; it only started appearing recently, on and off,
and now it seems to be there permannetly.

Once again, any idea as to what might be the cause of thsi
is greatly appreciated. Thanks in advance.

Chris
 
C

Chris

Hello again,

sorry to say this, but I've traced the fault to an onExit
event getting called in the subform's subform. Why that
happens is yet to be determined.

Thanks

Chris
 

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