Problem with a form in Access 2000

[mff.jhw]

Help, please!

I've got a problem programming in Visual Basic in Microsoft Access 2000.

I am trying to prepare a "Click" event on a button inside a form <A>.
Clicking this button should take users to another form <B>. But before I
open form <B>, I need to be sure that all the data filled up in the form <A>
is really updated on the database, not just an image on the screen. I have
tried with SAVE, REFRESH, REQUERY but these attempts didn´t work.

Can anyone help me to solve this problem?

Thanks a lot.

 

[Bruce M. Thompson]

Clicking this button should take users to another form <B>. But before I
open form <B>, I need to be sure that all the data filled up in the form

is really updated on the database, not just an image on the screen. I have
tried with SAVE, REFRESH, REQUERY but these attempts didn´t work.

Add the following lines of code just before the line that opens form <B>:

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

 

[Andy]

I have a similar problem with a combo box. I want the
data in the combox to refresh after another field is
updated. I have done this by moving to the next record,
and then back to the pervious record, however this is slow
and clunky.

Any suggestions?