Updating value immediately

[Jonathan Blitz]

I have a form built on an SQL Server table.

In the table I have a bit field which is represented by a check box in
Access.
I find that if I check/uncheck the box then it has no effect until I move
away from the field.
How can I make it happen immediately?

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."

 

[Gary Miller]

Put in Me.Dirty = False in the AfterUpdate of the checkbox
to force a record save.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[Rick Brandt]

I have a form built on an SQL Server table.

In the table I have a bit field which is represented by a check box in
Access.
I find that if I check/uncheck the box then it has no effect until I move
away from the field.
How can I make it happen immediately?

No effect where? In the table? Nothing you do in a bound form has any effect on
the table until the record is saved which usually happens when you close the
form or navigate to a different record. If you meant something else, you'll
have to explain further.

You can force a save in the AfterUpdate event of the CheckBox with...

DoCmd.RunCommand acCmdSaveRecord
or
Me.Dirty = False