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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
Link a text box based on drop down box with four options MS Word 365 0
Combo box 0
Populate a table based on check box status 2
Combo or list box 0
Combo or list box 0

Top