not in list drop down list data access page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to give my users an option for not in list in a data access page
drop down list. I have given them a link to a different window where they
can add new products. The problem is when they return to the initial window
the drop down list isn't updated to include their add. The only way it seems
to update is to reload the entire data base.

How can I update the ddl to include the new product?

thanks,
 
J said:
I'm trying to give my users an option for not in list in a data access page
drop down list. I have given them a link to a different window where they
can add new products. The problem is when they return to the initial window
the drop down list isn't updated to include their add. The only way it seems
to update is to reload the entire data base.

How can I update the ddl to include the new product?

thanks,
Click to expand...

Have you tried to requery the form?

Put code like the following in the After UpDate Event of your first combo:

Code:
Forms!FormName!ComboName.Requery
 
Back
Top