This still doesn't look like Excel to me.

You sure you shouldn't be asking in an Access group?

Squeaky wrote:

Either it won't work or I need more detail on how to set it up.
In design mode, I right click on the combobox and select view code. I see:

Private Sub ComboBox1_Change()

End Sub

Where do I put in the commands to refresh or reset? If I put it like this I
get an error:
Private Sub ComboBox1_Change()
Me!ComboBox2.Requery
End Sub

I tried the Lost Focus command and I can't get that to work either. I don't
know if I'm setting it up correctly or what.

More help?
Thanks,

Squeaky

"Dave Peterson" wrote:

This doesn't look like Excel's VBA. Are you sure you didn't search in an Access
newsgroup?

If you really meant excel, maybe...
me.combo2.clear
'to clear the list???
then code to add back whatever you need -- maybe using .additem????

Squeaky wrote:

I need to be able to refresh a second combo box (from the Control Toolbox)
based on the selection of the first combo box. I have seen many posts that
say to Code an AFTER UPDATE event for combo1 with a requery:
Me!Combo2.Requery
Where do I find this AFTER UPDATE? I am using Excel 2000
It is not listed in the declarations in VBA. I am not strong in VBA, just
getting started.

Thanks,

Squeaky

--

Dave Peterson


--

Dave Peterson