Combo Box Data

W

whitjl143

I don't know if I'm in the right place for this question.

I have a table (tblAggregates) that has the following fields: RatesFor,
Aggregate, Price, Status.

I have a form based on this table and a combo box based on the Aggregate
field.

My problem is this: the prices for the aggregates change frequently. I
want the combo box to only bring up the current rates (when the Status field
is 'Active'). However, on previous orders I need the information stay the
same with the old price that is now inactive.

I don't know if I need a query or what.

Thanks so much!
 
K

KARL DEWEY

Allow combo query to pull all records but have two sorts - Active/Inactive &
Aggregate.
This will allow display Aggregate selected before it was changed to inactive.
 
Top