Hi Guy
I have two tables with the all the same fields in them one is 2013 the other 2014
I want to have them use the same form, with a drop down combo box "2013" or "2014" and loads that table into the form, also these forms have subforms that are comments and there are 2 2014 and 2013
Whats the best way to do this?
I currently have a unbound combo box that has "2013 and 2014" to select from but am unsure how to code this to load the table according to year selected