Updating Forms HELP!

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

I have created a database that has customer details on the main form, the
customers are selected using a drop down box, if the customer is not present
in the list there is a button opening another form allowing a new customer
to be entered, is there a way of automatically up dating the previous form.

At present I have a button on the first form which refreshes the list
 
You could use the AfterInsert event of the the other form to requery the
combo on the first form.

You probably want to use the AfterDelConfirm as well, and there may be
several forms that have the customers combo. What we do is call a generic
function in the AfterUpdate and AfterDelConfirm events of every form. Once
most of the application is completed, we fill in the details of this
function (with a huge Select Case statement) to cope with all the
dependencies that arise. It takes a bit of work, but it is the best approach
we have found to handling the dependencies that do not even exist yet at the
time you are first developing your form.
 
Back
Top