combobox options

[Saintsman]

I have a data entry form where the combobox looks up data from a library &
stores libraryID (autonumber from library table)
I want this combox to only select from 'current' library items in order to
limit selections to most popular items - which I do via simple tick box &
filter in a query.
But there are times when users need to select from the full library and
select items which are not current and save that data as well.
The problem is that my original combo only shows current records. I have
tried limittolist = no, but that doesn't work - any suggestions please

Thankyou

 

[KARL DEWEY]

Allow combo query to pull all records but have two sorts - Active/Inactive &
libraryID.
Another reason for this is to be able to display libraryID selected before
it was changed to inactive.

 

[Saintsman]

Sorry - not quite sure where you are headiing with this I'm afraid
I added criteria in my query to show only current (popular) library items in
the drop down, but i need the combo on the form to allow any library items to
be added if selected from the full library - I have popup form with the full
library listed
This works OK as long as I don't limit the main form combo selction criteria