Query Form or Report?!?

[Patel79]

Hi all - Good morning!



I'm fairly new to Access so please excuse my ignorance.

I have a table with States, Zip Codes, Counties, and some other columns that have the pertinent data.

I would like to create a (Form or Report?) that you can open, Select the state(s) and the data under the state(s) appear - OR the user can select the State and Zip Code(s) the data for those to appear OR just zip code Or any combination.

Is this possible? If so, can you please help me our or point to where I can find the info?

Many many thanks everyone!!!!

[ranman256]

make a form that shows all records, (continuous form)
in the header put a combo box that has all states.
a text box for zip codes.
when user selects a state in the combo, filter the records to see only those records.
below is the code to do this:

sub cboState_Afterupdate()
if isNull(cboState) then
   me.filterOn = false
else
   txtZip = null
   me.filter = "State='" & cboState & "'"
   me.filterOn = true
end if
end sub

'vb for zip code box

sub txtZip_Afterupdate()
if isNull(txtZip) then
   me.filterOn = false
else
   cboState = null
   me.filter = "ZipCode='" & txtZip & "'"
   me.filterOn = true
end if
end sub

[Patel79]

Thanks so much RanMan!

Coding - uggh! I thought this could be done without coding haa. I'll definitely try this but real quick - apologies if my description was off, but instead of an input for zip code, I would like to have (multi)selection of zips under any given state/county.

For example a I can select State: GA, then I can either select the County or simply select the zips I need. OR I can select the state, then select the county(s) and the zips that fall under those county(s).

I hope that clarifies, and thanks again!

[NTC]

in the Continuous form, put your cursor in any field and right click - there you will see both sort and filter features - experiment with this.... if you seek to avoid coding this is an option