change select query conditions from inside form

[ricardozelaya via AccessMonster.com]

Is there any way to setup a combo/list box with zip codes so that when I
select a zip code, the query the form is based on only displays the records
corresponding to that zip code.

I know I can display the zip codes that I want by changing the zip code field
in query design view before opening the form.

 

[Allen Browne]

You can apply a filter to the form.

The example below assumes you have a Text field named Zip, and you want to
filter the form using an unbound combo named cboFilterZip:

Private Sub cboFilterZip_AfterUpdate()
If Not IsNull(Me.cboFilterZip) then
If Me.Dirty Then Me.Dirty = False 'save first.
Me.Filter = "[Zip] = """ & Me.cboFilterZip & """"
Me.FilterOn = True
End If
End Sub