i have set up a database query in excel to an external Access database, using parameters to allow me to auto update the information being queried. the parameter uses two entry fields "material" & "grade" to auto query my data and this works perfectly as a standalone excel sheet function.
i have subsequently created a userform in in VBA which has two comboboxes "material" & "grade", while the first combo "material" selection works fine, the "grade" combo fails to refresh to its updated data. why?
its as though the first selection combo is missing an "enter" function to confirm its selection.
is there some code i can include for this combo box to over come this??
currently working with office 2000