Disable txtbox by adding value in checkbox.

[sachuchem22]

I have one checkbox and one txtbox in form and i set txtbox disable by checked in checkbox by VBA code but problem is that when i checked in checkbox txtbox disable but when i go to next record without checked in checkbox txtbox is already disable. so how i solved this problem.

[BHo15]

You would probably want to add a Form.OnCurrent event that checks the status of the checkbox, and if it is not checked, sets your txtbox to enabled.

[sachuchem22]

Thanks BHo15 . But can you explaine how to i doit please . i am new user of ms accese7. so please Help me.

[BHo15]

Sure thing.

1) Open your form in design view (so that you can edit it).
2) The form properties ("Property Sheet") should be on the right side of the screen.
3) Select the Event tab.
4) On Current is the first listing. On the dropdown, choose [Event Procedure]. Then, click the elipsis (...). It should take you to the VBA editor.
5) Under Private Sub Form_Current(), you put something like this...

If Me.CHECKBOX-NAME = True ThenMe.TXTBOX-NAME = Disabled (I'm not sure how your disabling it)ElseMe.TXTBOX-NAME = EnabledEnd If
 

Hope that helps a little.