Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I have a list box that is populated by the records of a table. I want the records of another table to be removed from that list box.

Example: Table 1 (adds to list box):

entry1
entry2
entry3
entry4
entry5

Table 2 (subtracts from list box):

entry3
entry5

Final list box:

entry1
entry2
entry4

How can I do this?

share|improve this question
If you have questions about the access database please feel free to ask here. If you have questions about forms, programming in VBA, etc, then this is not the place. – JNK♦ Jul 6 '12 at 13:01
I suspect you are looking for stackoverflow.com or superuser.com – Remou Jul 6 '12 at 14:04
Hi, this question isn't a good fit for Database Administrators, and would be better suited to Stack Overflow. However, it looks like you have a history of writing bad questions on Stack Overflow, so what you might like to consider is rewriting some of those questions to be a better fit, so that you can continue to ask questions on Stack Overflow. If you need help editing those questions to get better responses, flag one of your own questions and ask for moderator assistance in the open form text box. We prefer to see questions get written that elicit good responses, and edits over new questions. – jcolebrand♦ Jul 6 '12 at 15:30
Let me also take a moment and explain why this question is off topic this morning: You're asking how to do something in VBA, not in MSAccess JET SQL. It could be if you said "I'm populating a listbox off of a query, and I can't seem to get the query to do what I want, here's a sample of my rows and the query I'm using, can you help me make this work?" but instead you've phrased this as a VBA question (because the answer can be coded in either VBA or JET SQL, depending on what you're doing). Hopefully this helps you understand how to improve this question? – jcolebrand♦ Jul 6 '12 at 15:31
@jcolebrand Well, I didn't ask about VBA, but it certainly is a way of doing it, I think. jcolebrand and JNK Ok, thanks for the information. I thought this was the place to ask it.. I'll ask over at superuser or SE. – Friend of Kim Jul 6 '12 at 17:36
show 1 more comment

closed as off topic by JNK♦ Jul 6 '12 at 12:51

Questions on Database Administrators Stack Exchange are expected to relate to database administration within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.

Browse other questions tagged or ask your own question.