Controlling fields on tab windows

[marnieg]

I have a form that has several tabs. Some of the tabs use subforms. The other tabs are just displaying data related to the main table. On the open of the form I am performing some security checks for making certain tabs visible or not. Now what I want to do is on one of the tabs that is just displaying data from the main table I want to conditionally disable certain fields.

So I'm trying to figure out how to reference those fields on that tab.

The tab is called "Preferences", so I currently have in my code

Me.Preferences.Visible = False

What I want to do is allow the user to have access to the tab, but not be able to change any field values. So I must set Me.Preference.Visible = True, but then how do I set the fields to "Locked" or "Disabled".

Thanks for any assistance in this manner.

Marnie

 

[spikepl]

Controls in a tab are referred to just like any other controls on a form - the tab itself does not enter into it at all.

 

[marnieg]

So I believe what you are saying is just refer to the fields on that tab using the form name.

Me.fieldname.Locked = True

where ME = "Leads" is the name of my form?

Thanks for your quick reply.