Form update problem

[bilbo+]

Hi, at the moment I have a main form with dfetails about jobs with a button
to enter customer details, this brings up a new form where you can enter
customer details that are new or existing, by clicking done it saves the
record and enters the unique cust no. into the main form. when in the main
form the cust no. is inputted there but the other details that should come up
corresponding to this only comes up when you change record and go back to it,
is there a way of getting it to update automatically? i have tried using
macros to save it etc but nothing seems to work.. Thanks, WK

 

[Damian S]

Hi bilbo+,

You are running into a few issues today, aren't you?

To refresh your main form, add a line of code into your pop-up form's done
button like this:

forms!MAINFORMNAME.requery

This will force your main form to requery its data source and therefore
retrieve the record changes.

Hope this helps.

Damian.