To use a combo as a filter first use the wizard to make your combo and pick
the field you want to lookup. Then go into the afterupdate event and type:
Me.filter = "[myfield] = """ & Me.yourcombobox# & """"
Me.filteron=true
> Okay I am working with a access database and I am trying to format the form
> to display certain information based on a combo box answer.
[quoted text clipped - 10 lines]
>
> any and all help would be greatly appreciated.
ChestMnednhlp - 12 May 2008 22:40 GMT
I'm not sure filtering is really what I am looking for, perhaps a rephrase...
when a certain state is selected in a combo box lets say - georgia
then I want two other feilds to become visible - "peaches" and "southern
hospitality" so the user can input information.
> To use a combo as a filter first use the wizard to make your combo and pick
> the field you want to lookup. Then go into the afterupdate event and type:
[quoted text clipped - 15 lines]
> >
> > any and all help would be greatly appreciated.