help required MS Access subform Object control.

[email protected] · May 2nd, 2011, 04:22 AM

hi,
i want to Enable or disabled form object(fields) depending on other fields value.
i.e m developing invoice software in MS Acess. and i want to disabled/enabled subform fields Invoice_Selection baseed on other field (Status) depending on two values
1= Order Placed
2 = Invoiced.
and an option field Name = Invoice_Selection.

so my question is, in a subform where (status) = Invoiced ,Invoice_Selection Fields object disabled. "only those where status = Invoiced" remaining will be enabled. (VBA Coding required)

m waiting for ur Response

Imar · May 2nd, 2011, 05:24 AM

Hi there,

Posting the same message over and over again in many forums is considered bad netiquette. You may want to review your messages and delete them, except for the one in the most appropriate forum category.

Cheers,

Imar

HiTechCoach · May 2nd, 2011, 12:48 PM

Quote:

Originally Posted by [email protected]

hi,
i want to Enable or disabled form object(fields) depending on other fields value.
i.e m developing invoice software in MS Acess. and i want to disabled/enabled subform fields Invoice_Selection baseed on other field (Status) depending on two values
1= Order Placed
2 = Invoiced.
and an option field Name = Invoice_Selection.

so my question is, in a subform where (status) = Invoiced ,Invoice_Selection Fields object disabled. "only those where status = Invoiced" remaining will be enabled. (VBA Coding required)

m waiting for ur Response

I normally use the form's On Current event to handle this when navigating to records. I use control's after update event to handle this for the current record.

Example for a text box:

Code:

If (Me.status <> "Invoiced") Then 
     Me.txtMyTextBox.Enabled = True
Else
     Me.txtMyTextBox.Enabled = False
End If

or the short hand

Code:

Me.txtMyTextBox.Enabled = (Me.status <> "Invoiced")