How to hide the last row (id*) for adding new record in a sub form .

Issa S.
Issa S. used Ask the Experts™
on
Hi All,,,

How to hide the last row (id*) for adding new record in a sub form .

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems Analyst
Top Expert 2007

Commented:
Open the Form that is the subform
On the Form Property sheet ... set the AllowAdditions property to False

Author

Commented:
Dear Joe,,,

If I do the above, can I allow Add, Del, Updt  thru Buttons on the Main Form?
Simply, I don't want the user to jump thru the record selection.
Thanks

Author

Commented:
Dear Joe,,,

If I do the above, can I allow Add, Del, Updt  thru Buttons on the Main Form?
Simply, I don't want the user to jump thru the record selection.
Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial