Updating value immediately

  • Thread starter Thread starter Jonathan Blitz
  • Start date Start date
J

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."
 
Put in Me.Dirty = False in the AfterUpdate of the checkbox
to force a record save.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Jonathan Blitz said:
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?
Click to expand...

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
 
Back
Top