Refresh MS Access Form/Query Based On Combobox Value -

Refresh MS Access Form/Query Based On Combobox Value -

pretty simple explanation. have table 10 entries, 5 entries year 2010 , 5 entries 2011 in column.

in query have, utilize *2010 filter out entries equal 2010 , display onl records.

on form, have combobox beingness populated each unique year (from different table). combobox values 2010 , 2011.

is possible, when select 2011, trim right 4 characters , utilize criteria refresh , requery form, done within vba?

you can refer value of command in query run within access session, long form contains command open.

class="lang-sql prettyprint-override">select * yourtable date_field_as_text "*" & forms!yourform!yourcombo;

so perhaps can utilize similar query form's record source, , me.requery in combo box's after update event.

if that's not close plenty want, please give more info info types of fields involved. adding brief samples of table info question help; please create clear whether "date" fields text or date/time.

ms-access access-vba criteria ms-access-2010