Enable form fields based on another fields input

  • Thread starter Thread starter Joseppi4Life
  • Start date Start date
J

Joseppi4Life

I have a form called frmIncident based on a table calle
tblInvestigations. (Please don't ask - :?
On the form, I have a textfield called MPsFileNumber and a checkbo
(Yes/No) called Criminal. What I'd like to do is have th
MPsFilenumber field inactive by default and only activate the fiel
when the Criminal field is set to YES

Is this possible, and how

Thanks in advance
 
In the form's Current event, put code along the lines of:

Me..MPsFileNumber.Enabled = ((Me.Criminal & "") = "Yes")

That's assuming that Criminal is a text field. If it's actually a boolean
field use:

Me.MPsFileNumber.Enabled = Me.Criminal
 
Thanks Douglas

Here's the code I've entered into the after update on the Crimina
field. It seems to be working

Private Sub cbCriminal_AfterUpdate(
If Me!Criminal = Yes The
Me!MPsFileNumber.Enabled = Fals
Els
Me!MPsFileNumber.Enabled = Tru
End I

End Su
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If field then checkbox and enable 1
Copy record info into new form 0
Restrict data in one field based on content of another 2
Click a subform field to open relevant form 5
apply filter to master form 9
Warning - Extortion Scam 2
Access 97 - autofill field value based on other fields in form 3
Hide Field based on Another 3

Back
Top