OK, it should look like this:
1. The property sheet should have [Event Procedure] in the AfterUpdate
event
2 Code assuming REX is Check38 (no space in the name):
Private Sub Check38_AfterUpdate()
Me.Check38 = True
Me.Dirty = False ' save the form
Me.Requery
End Sub
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
Good day;
I am not sure I know what you mean I am not the best with code. But the
"Private Sub Check 38" which is the check box in question, is
highlighted
yellow along with the ".REX" after "Me" is highlighed grey.
Do I need to insert a event procedure break or something there
somewhere?
:
On which line does your event procedure break?
If you have Break on unhandled errors set in the code window's Tools
Options, you should be able to spot which line is causing the error,
It
will
be highlighted in yellow.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
Hey I tried that, but it said Compile Error: Method or data error
not
found.
Any suggestions? Thanks
:
If the checkbox is on the form and bound to the underlying table or
query:
Me.REX = True
Me.Dirty = False ' save the form
Me.Requery
as an event procedure in the AfterUpdate event of whatever control
changes
the condition. If you are clicking on the checkbox directly, just
save
and
requery.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
How can a after update be completed on a check box. The reason I
need
this
is
I run a query report that draws from checked boxes. So I have a
form
"DualEmpl" with a check box [REX]. Also on the "DualEmpl" form
there
is
a
button that runs a query " bases on "yes" or checked boxes from
the
"DualEmpl" form. But for some reason I have to close the
"DualEmpl"
form
before the [REX] check box will update.
Any help will be greatly appreciated!!!!