Subform open edit only (no add new record)

[shallman]

Freinds,
I have a form that opens for edit only and has a subform that opens allowing new records to be entered in it's corresponding table. I want the subform to open so it does not allow the entry of a new record, only dipslay and edit of existing records.

What is the best way to do this?

Thanks,
SHallman

 

[chirpyform]

put the option add authorised to no in the subform

 

[natatbh]

Hi shallman,

On the properties sheet of the sub form set the allow deletions
and allow additions to "NO" and the allow edits property to
"YES".

natatbh

 

[shallman]

Thanks, Just what I was looking for!

SHallman