Removing Records from combobox dropdown list.

[jkdaddu]

I have created a database in Access 2007 for my friend's transportation work needs.

I have a payment form with a consignments detail subform ( Datasheet view to see, calculate sum of selected records freight value and print the entire rows of multiple records) based on a query with calculations.

In subform, there is a combobox field for consignment notes . The purpose is to select the Consignment note no from drop down list either one or multiple.

Every thing is done but what I am looking for is to remove the records (which have been already selected ) from drop down list to avoid repettion and also shortening the list for unused records to be used as the records flow is very high and dropdown list will become very lenghthy and long and create confusion to the user to choose records from mix list.

Kindly help. I am very new to this field.

[zmbd]

we need to know how you created the "combobox field"

if you used a table level multivalued/lookup field, and this is what is sounds like as there is no multi-select combobox-list in the form controls, then you've found one of the gremlins of this type of field. There simply is not any way to easily filter these down, nor remove the item without deleting it from the underlying record source.

Let us know what you have and we'll go from there. :)