atomatic update

[Bhagya]

Hi,

I have two tables - vendor and deals

I have two forms with the same names. On the "deals" form
there is a combo box, which shows the vendor name (from
the vendor table)

My problem is that after I enter the vendor information in
the vendor form and open the deals form - the combo box
does not show me the latest information

Is there any way I can automate this - i.e have my combo
box show the latest vendor information.

Any help would be appreciated

Thanks
Bhagya

 

[Al Campagna]

Bhagya,
After entering the Vendor Information, do a Requery of the Deals
ComboBox.
example... cboVendorName.Requery
That will update the combo with the latest Vendor info you added/changed.

 

[Al Campagna]

Bhagya,
When you close your Deals form... after adding/deleting/changing any Deal
data...
Refresh
DoCmd.Close
When you return to your original "calling" form, the cboVendor combo
should contain the updated info. I didn't test this, but it should do the
trick.