Combo box for list

[Danzig]

I am trying to create a combo box for my list, and dont exactly know where to start.

All I know is that I want to be able to mark some propects as not interested, wrong number, duplicate, etc. & have those sent to another table.

I would also like in this combo box to take the positives like sold, interested, hot lead, etc. sent to a seperate table.

Does anyone have any ideas on how I can make this happen?

[pbaldy]

You generally would not want to move them to different tables, though it can be done. I'd simply have a field in you main table for this status. You can then query the table for any status or combination of statuses.

[Danzig]

I'll try that. Thank you!

[Danzig]

That would work to run reports. However, I need to have certain names from the table be removed from the list. Say I had 250 duplicates, I don't want those to stay in my list. I would like to have them removed, and eventually charge the name company that sold them to me back next time I buy names.

I don't know much about combo boxes, as I am still learning, but is this possible?

[pbaldy]

You could certainly run some process based on the combo value, so if you chose "Duplicate" from your options, you could then copy the record to another table, delete it from this table, or both.

[Danzig]

oh so it does extract the info from the list when you run a query? I thought it just left the names in there..

[pbaldy]

A normal SELECT query doesn't change anything. You would need an append query (INSERT INTO ...) to copy the record to another table and/or a delete query (DELETE...) to delete from the first table.