Limit Records in a Subform

[Guest]

I have a subform as a datasheet within a form. I want to limit the number of
subform records that a user can edit to three for each main form record. Any
suggestions?

Thank You for your time in advance...

 

[strive4peace]

on BeforeInsert event of subform

if me.recordset.recordcount >= 3 then
msgbox "You may not add any more records",,"Cannot Add
record"
cancel = true
me.undo
end if


Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com