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

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Disabling a field in a subform from the main form

Susan has attended:
Access VBA course

by - delegate Susan [3 posts] (2007 Apr 24 Tue, 16:24) Reply

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

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

by - trainer David gold contributer [428 posts] (2007 May 21 Mon, 12:00) Reply

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

· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Company Roles in Visual Basic Training

Vba tip:

Stop Screen Flickering When Running Code

Running VBA code may cause the screen to flicker as the monitor is the slowest part of the program and cannot keep up with the very fast changes taking place.

To switch off the screen until the program is run enter the following code line:

Application.ScreenUpdating = False

The screen comes on automatically on completion of the program.

View all VBA hints and tips