Hi Chrism2,
I'm not sure if I have understood what you want correctly.. But this method can allow you to display additional/hidden fields or subform(s) from a user mouseclick.
Open frmMain. You will see a check/tick box and a command button.
Command Button:
"Reveals" several new fields (belonging to the main form/main table) that can not be edited or deleted. Just for display.
There's an event procedure in the OnClick() property of the button.
These fields must be set to Hidden by: Properties>Format Tab>Visible>No
Also: Properties>Data>Enabled>No and
Properties>Data>Locked>Yes
This stops the user from "changing the data" and won't affect what you're doing on the current record etc.
Check Box:
The check box, when "ticked" reveals a subform (and vice versa). Same principle. The subform is set to Visible>No by default.
There is an event procedure in the AfterUpdate() property of the checkbox
To BLOCK users from deleting, editing etc on the subform, set the SUBFORM properties by going to Properties>Data and:
AllowEdits
AllowDeletions
AllowAdditions
DataEntry are all set to NO.
You can use VB as well to toggle the Allowedits... properties as well so users can edit the data, say, by having to click another button to confirm.
P.S - I've just banged this together using mostly MS wizards so is ugly as sin and I've not bothered to label correctly.. but it works, and you can see how to do it I think.
HTH - Junkee