Changing object properties of single record in multiple item form

[jobrien4]

I have a multiple item form that displays multiple items and allows the user to edit these items from one form.

There is a combo box which includes the value "Other". When this is selected, I would like a text box/label to appear for the user to specify what the Other is.

However, when I try:

If Combo = "Other" Then
Me.SpecifyLabel.Visible = True
Me.Specify.Visible = True
Else
Me.SpecifyLabel.Visible = False
Me.Specify.Visible = False
End If

It sets all of the SpecifyLabels and Specify's Visible = True/False (not just the record they are on). Is there a way to make them change the properties only for those objects in the current record?

 

[boblarson]

If this is in a Continuous form view or Datasheet form view, which I'm guessing it is one of them, then no - you can't do it for a single record. It would have to be in Single Form View for it to work.

 

[vbaInet]

I also suspect you're talking about a Continuous form. If this is the case then one option would be to enable/disable the control depending on the value of the combo box.

 

[boblarson]

I also suspect you're talking about a Continuous form. If this is the case then one option would be to enable/disable the control depending on the value of the combo box.

...using the After Update of the combo and the On Current of the form.

 

[vbaInet]

...using the After Update of the combo and the On Current of the form.

... and that is if the form is a Single form. But if it's a Continuous form or a Datasheet then you need Conditional Formatting for disabling/enabling the control lol.

 

[boblarson]

... and that is if the form is a Single form. But if it's a Continuous form or a Datasheet then you need Conditional Formatting for disabling/enabling the control lol.

No, it would not NEED to be using CF as all of them would be disabled/enabled as it is viewed, but it would not be usable in any record other than one that it matched in, because of the current event would disable it if you moved to another record to try anything.

But CF does make it only have to be done in one place and it will make it look better and not like they are all enabled when in reality only one would be enabled (able to be used) at any time.

 

[vbaInet]

I don't remember if CF enable property in older versions didn't work well but it does in 2007 See attached. In records 4 and 5 the "fruit" control is disabled.