Append data

J

JenS

I want to appead data from one table to another, but first I want to view the
data to make sure it is correct. I want to type in a 16 digit ID number,
view the owner data to make sure I have the right person, then append that
record to a new table. What is the best way to do this without having to
retype the ID number again?
 
B

boblarson

1. Make a form to do the search from.

2. Use a COMBO box to have the ID selectable so you don't have to type it
all in

3. If you have a form bound to the data source, you can use the wizard for
adding a combo box that will bring up the record based on the selection you
made. It is the third option available in the wizard (below Store Value for
Later Use, and Store Value in Field - or something to that effect).

--
Bob Larson
Access MVP
Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________
 
J

JenS

I added the combo box, but I don't have a 3rd choice in my wizard. I only
have "Remember the value for later use" and "Store that value in this field".
I am working in Access 2002.

This didn't solve my problem, any other suggestions?
 
B

boblarson

If you don't have the third option then you didn't build the form so that it
was bound to the table. It needs to be a BOUND form for this option to
appear.
--
Bob Larson
Access MVP
Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________
 
J

JenS

I changed the form to a bound table and the third option was available. Now
I can type in the number and see the owner name. It takes a long time
becaues my table has over 117,000 records. Now, how do I append this ID
number and the corresponding data to a new table?--
JenS
 
S

seppo

JenS said:
I added the combo box, but I don't have a 3rd choice in my wizard. I only
have "Remember the value for later use" and "Store that value in this
field".
I am working in Access 2002.

This didn't solve my problem, any other suggestions?
Click to expand...
 
Top