Restricting SubForm to One Record Entry Per Parent: Access 2007

A

Alcide

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.
 
M

Maurice

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
 

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

Similar Threads

Link two subforms in datasheet view (one sub-form, one sub-subform 1
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Subform entry check 1
ACFormatHTML Only Outputs the Parent Form - Not The Subform 2
Problem with subform parent/child linking 2
new record in subform 1
Form with one-to-many rows 1
Display Child Records in subform 7

Top