Access Form check box

[T588]

I have a form with a check box named "check if same",
Through an event procedure, checking the check box duplicates the "sold to" values to the "ship to" area on the form and removes the values if unchecked (if checked by mistake).

Problem is that tabbing through to the end of the form and into a new record the check box remains checked. I've tried various "OnCurrent" VB to no avail?

Any ideas would be appreciated.

Thanks
Vince

 

[Fornatian]

Is the checkbox bound to the forms source table? If it is check the default value in the table. if it's not change it in the OnCurrent event.

If Me("Check if same") = True Then
Me("Check if same") = False
End if

 

[T588]

Thanks - worked perfectly!

Vince

 

[Fornatian]

Just a small piece of advice, it unwise to put spaces in the names of fields because the spaces are replaced with underscores dependent on the calling method you use for instance:

"My Field" would be Me("My Field") or Me.My_Field

It is much easier to use 'camel humping' to concatanate words like 'MyField' which still reads the same but doesn't cause confusion as it is always MyField no matter how you reference it:

Me("MyField") or Me.MyField