Returning to Record after running Macro

[Dazbil76]

Hi,

I am using Access 2000. I have designed a macro that sits behind a button in
a form that when pressed updates some fields in my form. However, the macro
then opens the Form at the beginning again and not at the record that I was
on.

Is there anyway of setting my macro to re open the form at the same record I
was on when I press the update button?

 

[KARL DEWEY]

If the form does not close or open another form set to not visible you can
add a textbox (not visible if using currrent form).
First action in macro to Set Value of text box using something of current
record to identify it.
Do you present macro action followed by FindRecord using data from the text
box.

 

[KARL DEWEY]

If the form does not close or open another form set to not visible you can
add a textbox (not visible if using currrent form).
First action in macro to Set Value of text box using something of current
record to identify it.

Do your present macro actions.

If the cursor is not in the field needed to find the record then first you
need GoToControl to have focus on the field. Reference it like this --
[Forms]![YourFormName]![TextBoxName]

Then in the FindWhat you enter the string, date, or whatever data you are
looking for in a record. In this case you use
[Forms]![YourFormName]![TextBoxName] where you stored the search data in the
FindWhat.

--