Restricting SubForm to One Record Entry Per Parent: Access 2007

Hello All,

I have a one-to-one relationship between two table. I have successfully
added the subform, but I get the option to add additional child records in
the Datasheet View. This means that when a user tabs to the next row and
enters data they get an error--and they should.

Question: How do I restrict the subform to show only one row in Datasheet
View?
I hope I was clear. Feel free to ask for clarification.

Thank you in advance for your assistance.

Alcide,

You have two options here. If the records are already added to the source of
the subform you could set the "Allow additions=no" option in the
formproperties.

You can also hide the navigationbuttons and set the cycle option of the form
to current record, that way the user will always stay in the same record. In
combination with the hiding of the navigationbutton you have a good
combination.

hth
--
Maurice Ausum


"Alcide" wrote:

Hello All,

I have a one-to-one relationship between two table. I have successfully
added the subform, but I get the option to add additional child records in
the Datasheet View. This means that when a user tabs to the next row and
enters data they get an error--and they should.

Question: How do I restrict the subform to show only one row in Datasheet
View?
I hope I was clear. Feel free to ask for clarification.

Thank you in advance for your assistance.