At the moment i have a refresh button which the user has to click before clicking another button to open a different form. Is there a way of adding a refresh function to the other button so it refreshes the form before opening the new one????

Thanks a lot,

Neil.

I don't understand the question.

What's the object of refreshing a form immediately prior to opening another form? What are you reallly trying to do?

Refresh, requery, and repaint are not the same.

Don't forget ReCalc as long as we are listing the "re" words http://www.access-programmers.co.uk/ubb/smile.gif Also, if you are attempting to save the current record,use an explicit save command rather than relying on an ancillary effect of another command.

DoCmd.RunCommand acCmdSaveRecord

OK this is the problem, when you open a form and make changes, then without closing that one, open another form and make changes, then when you try to close both forms you are given the option to save only one set of the changes you made. So far my user is having to click a refresh button on the first form before she opens the second form.

What i was asking therefore is can i have one button that can do both of these things simultaneously.

Thanks for the advise pat but i dont know where the syntax should be put! Is it possible to asign it to a button and then add another line of code which will open the second form? If so could you please let me know what that code is too???

Thanks very much,

Neil.

Any help here please???

Neil.

In the code of the button that opens the second form, why don't you add - me.refresh
just before the code that opens the form?

Col

You have to save the first record changes before you can view them on the second, having made changes again on the second you'll either need unbound forms to undo the changes made to the first or code.

Sorted, thanks colin, i used [forms].[frmOrder].refresh.

I put that code in before the open form function and its all sorted now.

Cheers,

Neil.