Check Box Populate Reletd to Text Box - 2003

[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!

 

[Jeanette Cunningham]

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

 

[Beetle]

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.

 

[Judi]

Thank you, It worked great!!

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

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

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]

Thank you, It worked great!!

You are my new hero... along with Beetle!!!