Cobmo field limit - I have searched the forum!

[John Jnr]

Question:
I have a combo field list
The combo is linked to table where some of the field names are years: 2002, 2003, 2004 etc.
Can I limit the combo to only select these years not other text based field names?

Thanks . . . . . again!

J

 

[Fizzio]

Base the combo on a query, just pulling the years from the table. set the unique records in the query properties to Yes and set the Limit to List in the combo properties to yes.
HTH

 

[John Jnr]

Fizzio,
How can you get a query to only bring up field names such as 2002, 2003, 2004?

Cheers

John

 

[Fizzio]

Sorry, I may have misread your question. I thought you meant values stored in the database with the values 2002,2003,2004 etc.
If you really mean field names, I would revisit your Db structure as I'm sure it is 'frowned upon' to store years as field names as it is possible to filter data by year stored in the data.

You can set the combo to just show a value list. set the rowsource type to value list and the rowsource to 2002;2003;2004;etc. but doind this will depend on what you want to do with the combo.