I don't want to limit to list!

[FISHiEE]

Hi,

I am trying to display data from a table. One of the fields is entered via a combo box. When displaying that data on a form I need to be able to allow items not on the list(created by a select query) to be displayed for this field. The data was created some time ago and it seems that records have been deleted in certain places which has resulted in inconsistent data.

I am happy resticting data entry for new records, but need to allow items not on the list to be displayed for historical data. Data entre and displaying of historical data take place on seperate forms so this is no problem.

My problem is that I am only able to disable limit to list if I make the bounded column anything other than 1 and doing this displays the wrong data!

Am I attempting the imposible or if not, can anyone help?

 

[JMG]

add another command button on the form with the explanation that if the data is not on this list "go here"
the button opens another form where info is not limited to the list

you can even have another combo box on the same form to do the same thing.

 

[FISHiEE]

THanks for the help. Further investigation revealed the data to be corrupt. For several records, simply deleting the last character and then adding it again made it accepted by the lookup list for some weird reason. For the odd couple of missing items I'll just add them to the list as suggested.