Append query help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list box (lstSchedule) with row source tblSchedule in Form1, when I
Double-click this lstSchedule I would like the selected records (only
selected) to be appended to the end of another table (tblMain).

Any help or tip is much appreciated!
Thank you,
Adnan
 
I think I figured this out. I’ve created a Query (Select query) that will
open selected record out of the lstShcedule (with criteria NumberID only),
then this particular query is being ran by another query (append qry) that
inserts this single record into the other table (tblMain). Just what I needed.

Just wanted to post this so that the others could maybe benefit.

Thank ya all.
Adnan
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Query Won't Work 2
How to copy curtain data fields from excel to access table via VBA 2
Append Queries in 2007 5
Append Query Issue 0
Append Query 11
Append Query 1
Append query? 3
Append only Null records in table 2

Back
Top