commiting of changes at checkbox

[SePp]

Hi

I want to select rows in a form via a checkbox. At the same Form I
want to click a button and I make another Select statement.

But at the moment I click at the button the changes are not made in
the database. First I have to go out of the form and then re-enter the
form and after this procedure I can click the button and it is
possible to see all the slected items.

Is there a way to commit the changes straight at the moment I clicked
the checkbox.

(I tried already form.requery, but I don't like that way because the
user loses the focus)

Thanks in advance.

Kind regards
Sebastian

 

[Guest]

Try putting this in the code of the button before you do any actions with the
button.

me.dirty =false

hth

 

[Douglas J. Steele]

If Me.Dirty = True Then
Me.Dirty = False
End If

 

[SePp]

If Me.Dirty = True Then
Me.Dirty = False
End If

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)












- Show quoted text -

Thank you guy's. You helped a lot!

regards
Sebastian