Single record view on subforms

[micromoth]

I have a tabed table the first tab is the parent to the other five
child subforms. How do I set up a single record view on the five child
subforms?

Can I remove the FK id number control from the subforms for simplisity?

 

[Roger Carlson]

In the form properties of each of the subforms, set the Default View to
Single Form.

Yes, you can remove the CONTROL that has the FK, but you must have the FK in
the underlying query.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[micromoth]

EEH -- My subforms are forms that are directly linked to the underlying
tables. Will this do as a substitute for a query. As far as I know it
should be OK. Can you confirm this is OK Roger, and that you didn't
specifically mean a query? I know it is pedantic but I would rather
get it wright from the start.