Form closes, then a warning

[Superguppie]

Hey there,

When i close a form, it will automaticly op another form with a Where-condition Ticketnummer = ticketnummer

de form opens and i see the correct ticketnummer and then it has also a checkbox wich is not visible but is active, als afmelddatum is not visible but active.

now the checkbox must be unchecked (its always checked when this forms opens) and it works, but i get all the time a warning, that another user is editing the record, en I click ignore and the checkbox is unchecked, now i want that message to go away, any ideas??\

Thanks in advance,

Superguppie

 

[TheAceMan1]

Superguppie . . .

Try changing the code for setting the checkbox to:

[blue]   DoCmd.SetWarnings False
   Me![purple][B][I]CheckboxName[/I][/B][/purple] = False
   DoCmd.SetWarnings True[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[Superguppie]

ok, I tried your code, it still gives the error when form closes..... also i tried to delete docmd.setwarnings True so the warnings stay off, but then the message is gone and the checkbox is also still checked, but the message ask me if i want to ignore it or continue, when i ignore it the checkbox wil uncheck, when i continue the checkbox stays checked,