Me.textbox.Enabled ?!?

[Poot]

Hiya,

I was wondering if it were possible to enable textboxes in a form only after a user has pressed a button.

See what I have done is let the user select a company - from here a hidden subform opens up allowing the user to then interact with it! - the user however has to choose a week of the year to hopefully then interact with the data associated with that week.

Is it possible to have "enabled = false" on a textbox.. I have tried it in VBA but get nowhere really, until the user chooses a week and then have it "enabled = true"?

Me.RoomType.Enabled = False

... would be the textbox that would be shaded out, or so i thought as I have done this with buttons before!

Thank you for any reply.

Regards,
Poot.

 

[norman]

Hi

Set the visible property of RoomType to 'no'

In the after update event of the combo/list box or button, whatever is triggering the next stage

If Me![YourCombo or listbox]= yourcondition Then
Me!RoomType.Visible = True
End If


HTH

Norman

 

[chewy]

can you post you code or preferably your DB?

 

[Poot]

Excellent

If Me![YourCombo or listbox]= yourcondition Then
Me!RoomType.Visible = True
End If


HTH

Norman

Excellent ..... thank you that is it! For want of my inadequate brain I couldn't see that it was visibility..ironically!! that was needed.. and a ! and not a .

Cheers!!