Limit Records in a Subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bironmx - 28 Feb 2006 17:55 GMT

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

Reply to this Message

strive4peace - 28 Feb 2006 18:09 GMT

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

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

Reply to this Message