Z
Zadi Friedrich
Hi Everyone,
I have two forms in an ms access database: FormA and FormB. FormA has a list
box based on a table Employees that display all the employees. FormB is an
unbound form that is used to input data in the different text boxes and a
visual basic routine saves all the information in the table Employees. After
the new record is inserted it shows in the list box Employee in FormA as
expected with the instruction: Forms!FormA!LstEmployees.Requery. The problem
is when I select an employee from the same list box in FormA and edit his
info in FormB and call a vb routine from FormB to update the data in the
table Employees, the changes don't reflect in the list box Employees in
FormA. How can I get to the bottom of this?
I have two forms in an ms access database: FormA and FormB. FormA has a list
box based on a table Employees that display all the employees. FormB is an
unbound form that is used to input data in the different text boxes and a
visual basic routine saves all the information in the table Employees. After
the new record is inserted it shows in the list box Employee in FormA as
expected with the instruction: Forms!FormA!LstEmployees.Requery. The problem
is when I select an employee from the same list box in FormA and edit his
info in FormB and call a vb routine from FormB to update the data in the
table Employees, the changes don't reflect in the list box Employees in
FormA. How can I get to the bottom of this?