The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Disabling a field in a subform from the main form

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

vba courses london - Disabling a field in a subform from the main form

Resolved · Low Priority · Version Standard

ReplyTue 24 Apr 2007, 16:24Delegate Susan said...

Disabling a field in a subform from the main form

I have a form with a subform in it. I can disable the fields in the main form with me.fieldname.enabled = false but I also need to disable all occurences of another field in the subform which could have several occurrences. How do I do this?

Thanks.

Sue

For upcoming training course dates see: Pricing & availability

ReplyMon 21 May 2007, 12:00Trainer David said...

RE: disabling a field in a subform from the main form

Hi Susan

Sorry for the delay in getting back to you, but this was a slightly complex VBA question and we had to wait for one of our advanced VBA trainers to become available to answer the question.

So our trainer Peter has the following code for you.

Function DisableFieldOnSubform()
'Main Form is called Orders
'Sub Form is called - Orders subform
'and field is called unitprice.
'This form arrangement can be found in Northwind.mdb

Forms.Orders.[Orders Subform].Form.UnitPrice.Enabled = False
End Function

Hope this helps

David

VBA articles

· What Are Modules In Excel VBA Coding?
· VBA With Excel - Making The Working Day That Little Bit Easier
· A Helping Hand For Your Business, With VBA And Microsoft Office
· Starting Out With Excel 2007 VBA Using The Macro Recorder
· Microsoft Excel, Tailor-Made For Your Business Thanks To VBA

Vba tip:

Use VbNullString instead of

When needing to default a String variable back to it's default of "" use vbNullString as in the following example:

Sub ClearText()

Dim strEmpName As String

strEmpName = "John Smith"
MsgBox strEmpName

strEmpName = vbNullString
MsgBox strEmpName

End Sub

View all VBA hints and tips

Is PowerPoint the best was to set up org charts?

» Forum post: Org Charts

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions