NEW ISSUE: List Box preventing query

[kspabo]

What I have right now is a query that shows a few columns of data when I make a selection in my combo box. What I'd like to figure out, is have the query log multiple rows of information. What I mean is, if I make Selection1 in my combo box and then proceed to choose Selection2, I want the query to store two rows of data displaying the columns of Selection1 and Selection2.

[burrina]

So even though you select ONLY One value, you want the query to show 2 values? Then set the Combo Row Source to reflect both selections and then refer to that value in your query,i.e.
Something.Column(2) for example.

HTH

[NTC]

I don't disagree w/ Burrina - though I interpret your post differently: A combobox holds the value of what is selected. You are using this value as a criteria of a query. When you change the selection of the combobox - of course the criteria of the query changes too - - - and the prior criteria is gone. That's the way it is. What you might do is add a step where the result of the query is written into a temp table made just for the purpose of holding the query result. Then you can change combo selections, get a new query result - and write that over to your temp table. This way you can have unlimited changes to your combobox and see them all in the temp table.... of course at some point you will want to clear that temp table I would think but that's a different issue........

[kspabo]

I'm trying to achieve exactly what NTC described. As I'm entirely an Access noobie, could you direct me to some resources to help me figure out how to do this all? First, how to have a query write to a table and second to have that table to be able to be cleared. Thank you so much!

[NTC]

to write new records into an existing table: Append Query
to delete records from a table: Delete Query

those are the topics to look up

[kspabo]

EDIT#3:

So I've been able to figure out everything I need so far but two things that are preventing me from finishing this.

1. I'm getting the message "The database engine could not lock table "tblLineSheet" because it is already in use by another person or process" when I attempt to use my Update query that resets the AutoNumber field to 1.This has occurred ever since I added the List Box with a RowSource directed towards the table.

2. How do I create a button which exports my table to a .csv file?

[kspabo]

Ignore my last post, I have been successful at answering my own question. I have one final thing that i need to figure out in order for me to be done.

So I've created a list box on my form that shows the table as things are added. Here's where I'm running into trouble: The query I've made that resets the AutoNumber column for the table is getting the error "The database engine could not lock table "tblLineSheet" because it is already in use by another person or process". What is a way around this?