Combo Box

[Duane]

Is it possible to create a combo box that will query 4 fields of a table the
database is linked to and then insert the data into like fields in a
different table?

I created a comb box that queries the number, lastname, lock, and unit of a
linked table. I have all the properties set so you can see all four columns
in the box. number is a unique field and I can type the number in the box
and the corresponding name, lock, and unit are visible. I would then like
to have the information inserted into like fields in another table.

Can anyone help me with this? If there is a better way to achieve this, I
would be most interested in hearing about it. I am all for learning more
stuff .

Thanks very much..

 

[Guest]

Duane,

There is no need to post the same question twice in less than one hour.
Repeating a post of a question is generally considered acceptable only if a
full day has gone by without a reply.

Check out the answer that MVP John Vinson provided to your original post.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Is it possible to create a combo box that will query 4 fields of a table the
database is linked to and then insert the data into like fields in a
different table?

I created a comb box that queries the number, lastname, lock, and unit of a
linked table. I have all the properties set so you can see all four columns
in the box. number is a unique field and I can type the number in the box
and the corresponding name, lock, and unit are visible. I would then like
to have the information inserted into like fields in another table.

Can anyone help me with this? If there is a better way to achieve this, I
would be most interested in hearing about it. I am all for learning more
stuff .

Thanks very much..