REFRESH DATA IN FORMS

  • Thread starter Thread starter Elisa
  • Start date Start date
E

Elisa

HELLO EVERYBODY
Can anyone help me with this problems:


I have a combobox and I would like that when I choose an element from
this combo, the other fields in the form refresh with the data of the
record related to the element I chose in this combo.

In the same form A, I can choose an element from the combo, and I can
open an other form B to cancel the record related to the element I
chose. After having deleted the record, I would like the list of the
combo in form A be refreshed automatically in order to eliminate the
element I deleted through form B.

Cheers
Elisa
 
Base the form on a query that uses the name of the combo box in its
WHERE criteria. Refresh the form in AfterUpdate event of the combo box.
For the second part of your ? all you need to do is requery the combo
box in the AfterUpdate event of the popup form B (assuming it is based
on a query or table).

Pavel
 
Back
Top