I'm trying to set up a form which s

[birdjfk]

I'm trying to set up a form which searches by Company Name (there are duplicate names-so I set up a query which shows company name unique) I'm using a combo box to display these names. When the user selects a company name, then I want all the records with matching company names to be filtered. The user should be able to next and previous through the filtered records (through a query I imagine). I guess I'm having a hard time with the structure of this and how to set up the combo box. I would appreciate any suggestions.

Thanks in advance.

 

[danvlas]

Assuming your combo lies on the form you want filtered.
Assuming your combo is unbound and residing in form header or footer.

Private Sub ComboName_AfterUpdate()
Me.Filter = "[CompanyName] = '" & Me.ComboName & "'"
Me.FilterOn = True
End If

Then use the navigation buttons to move from one filtered record to another.

Good luck



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[birdjfk]

Thank you for your assistance, I won't be able to get back to the project until Monday, just wanted to thank you.

Julie

 

[birdjfk]

Thank you, that seems to have worked.

Julie