Access Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an unbound combo box on my form with a value list. This value list
has the names of different tables for different years of data. In my form I
am querying my source table based on specific fields on the form. I would
like to have the unbound combo box to be able to choose the table for the
record source for my form but have been unable to do so. Can it be done and
if so, how?
 
In the after update event of the combo box you could have code like:
Me.RecordSource = "SELECT * from [" & Me.cboTables & "]"
 
I should have also questioned why you have different tables for different
years.
 
I have an index field that is autonumber as well as no duplicates and it is
used to identify each quality record in the table. It is for use in the QC
department and they wanted that field to reset to 1 and the beginning of each
year.
 
Not a good enough requirement to divide years into tables. There are lots of
ways to calculate sequences within a group of similar records.
 
With 12 Years of Quality Records of over 9000 records per year and all
requiring a unique index number, how would you recommend I acclomplish it.
Don't recommend using a formated year as a prefix in the field, because I
used that for years with much heart ache with it bouncing numbers.
 
I would add a column for the year and use a single table. Make sure you set
the proper indexes.
 
Back
Top