Search results

I have 2 problems. First ill give you a little background I am making a form for a database, where the table im using was designed so that each column name had the year in it. An example of this would be 2007department, 2007salary, 2006department, 2006salary. Each year someone goes into the...

Ahh I totally forgot I could set the controlsource programmatically. I think what ill do then is on page load, set the year then do what you suggested. Thanks.

I have a table that keeps track of data on a per year basis. For some reason the person who orignally developed it set it up so that the field names contained the year and that with each new year they just added more fields So the table design would look like this... Table items ---------...