Hep with combo boxes

octatyan

Registered User.
Local time
Yesterday, 18:29
Joined
Jan 10, 2003
Messages
36
Hi, I have a form that displays information about students and their hobbies.

This form has the following data: student first name, last name, ID #, and hobbies.

There is also a combo box that lists all students (there are 5 students in this database).

When adding a new student using this form (student #6), the student is not updated in the combo box. To update the combo box, you must close the form and reopen it again. How do I make the program automatically update the combo box so that student #6 is there after I enter and save #6's record?
 
octatyan,

You should use the AfterInsert event of the form to do a
Me.YourCombo.Requery.

Wayne
 
ok thats works, but now I have the same problem with a form and a subform. How do I make the main form requery after I insert a record into the subform?

thanks for any help
 

Users who are viewing this thread

Back
Top Bottom