Subform records

[Jenny]

Hi there

I have a mainform which the user enters records into the tblevents and a
subform which enters records into tblinvoice. Although the relationship
between the tables is one to one, multiple rows appear in the tabular subform
for a user to enter more than one record. Then of course should they attempt
to an error message displays saying the changes will not be succesful as it
weould create duplicate values in the pkey or relationship.

Have I made a glaring error? Or is there an easy way to restrict entries to
one record only on the subform that I have missed?

Many thanks for your help

 

[tina]

no, you haven't made an error - the subform is working normally. since the
two tables have a one-to-one relationship, the easiest way to stop the user
trying to enter a second record in the subform might be to set the subform's
DefaultView property to Single Form, set the Cycle property to Current
Record, and set the NavigationButtons property to No.

hth