Filter form based on combo (was Is this Possible)

[Arsalan]

I want to know that is this possibel when i select Month from Comobox(as mention in pic) then only selected month data will show in detail fields?


Please Help!

[pbaldy]

Sure; you can change the record source of the form or set its Filter property.

[Arsalan]

thanks for giving me response. One more thing i want to clear that if i want to filter january data then what i do?

[pbaldy]

Presuming the combo contains the month number:

Me.Filter = "FieldName = " & Me.ComboName
Me.FilterOn = True

[Arsalan]

Thanks alot sir.

[pbaldy]

No problem.