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,

Signature
Jason
dneagle - 08 Dec 2006 14:45 GMT
>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
[quoted text clipped - 5 lines]
>
>thanks,
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

Signature
David