Update a bound field using a listbox

[webmeister]

I have a form with several fields bound to a table, and also a listbox of records that are not bound to any table. What I want to do is to be able to double-click a record in my listbox and have the record show up on my form in a particular bound field, and also become a part of the underlying table's record.

Is it possible to do this? If it is, how would I do it?

Thanks in advance to all who are willing to help!

 

[popeye]

Try This

I think this may help... if it does let me know... I had to do something like this for a project this year.

 

[webmeister]

popeye,

Thanks for your reply. I'll take a look at your file and will let you know if it works on my question. Thanks again!

 

[webmeister]

popeye,

That did the trick! I appreciate your help..... saved me a bit of time.

Thanks again!

 

[popeye]

happy to help... you can use it to add information to multiple fields depending on which column in the listbox you refer to and also on the amount of information stored within the query that is used for the record displayed in the listbox.

Think we both earned our salary for the day