Drop down box problem

[whitjl143]

I have a form based on a table. One of the fields is called Materials and it
has all of the materials and their prices for last year and this year. My
problem is that I only want to see the prices from this year in the drop down
box. I can't use a query to filter only this years prices because that
messes up my previous years records. I think I have probably over-thought
this to death. Is there a way to do this?

Thanks so much for the help.

 

[KARL DEWEY]

One of the fields is called Materials and it has all of the materials and
their prices for last year and this year.
This sounds like three fields displayed in the drop down box.
The way I do it is to sort it like this --
SELECT Materials, Price FROM TableX ORDER BY Materials,
FORMAT([MaterialDate], "yyyy") DESC;

All of the current year prices will be on top. I do same with other data
like Termed employees, and any old stuff.

 

[John W. Vinson]

I have a form based on a table. One of the fields is called Materials and it
has all of the materials and their prices for last year and this year. My
problem is that I only want to see the prices from this year in the drop down
box. I can't use a query to filter only this years prices because that
messes up my previous years records. I think I have probably over-thought
this to death. Is there a way to do this?

Ummmm... why can't you use a query!? A query shouldn't "mess up" data in a
table if it's just a select query populating a combo box!

What's the structure of your table, and the rowsource of your combo box?