Check Box Populate Reletd to Text Box - 2003

  • Thread starter Thread starter Judi
  • Start date Start date
J

Judi

I am using Access 2003.

I have a form on which there is a text box indicating if the current record
is a revision and if so, what number revision. I also have a check box
indicating whether to include the current record in a report.

I need to make the check box false (empty) if there is anything in the
Revision field. I also want to block the user from being able to re-check
this box.

If you can help me, I would appreciate all of your help. You guys are
wonderful and I am working towards being able to help someone else down the
line. (I do mark all of my questions as answered when they are answered, I
know that helps the question to show up in later searches.)

Have a great day!
 
Judi,
assuming a single form (not continuous)
you can use code something like this:

If Not IsNull(Me.RevisionControlName) Then
Me.CheckBoxName = False
Me.CheckBoxName.Locked = True
Else
Me.CheckBoxName.Locked = False
End If

Replace the obvious with the names of your fields and control names.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Some code like the following might work;

If nz(Me![YourRevisionTextBox], "")<>"" Then
Me![YourCheckBox] = False
Me![YourCheckBox].Locked = True
Else
Me![YourCheckBox].Locked = False
End If

You would want to put the code in both the After Update event of your
revision text box and the Current event of your form.
 
Thank you, It worked great!!

You are my new hero... along with Jeanette Cunningham!!!

Beetle said:
Some code like the following might work;

If nz(Me![YourRevisionTextBox], "")<>"" Then
Me![YourCheckBox] = False
Me![YourCheckBox].Locked = True
Else
Me![YourCheckBox].Locked = False
End If

You would want to put the code in both the After Update event of your
revision text box and the Current event of your form.
--
_________

Sean Bailey


Judi said:
I am using Access 2003.

I have a form on which there is a text box indicating if the current record
is a revision and if so, what number revision. I also have a check box
indicating whether to include the current record in a report.

I need to make the check box false (empty) if there is anything in the
Revision field. I also want to block the user from being able to re-check
this box.

If you can help me, I would appreciate all of your help. You guys are
wonderful and I am working towards being able to help someone else down the
line. (I do mark all of my questions as answered when they are answered, I
know that helps the question to show up in later searches.)

Have a great day!
Click to expand...
Click to expand...
 
Back
Top