Display only

[Larsporsenna]

Hi
Thanks for the help with the combo box, but I knew I'd be back.
I have a table of Asset Types that I'm using as a combo box to populate an Assets table. The Assets Type contains Asset Ref and Asset Description.
Using a combo field I can select the correct Asset code and insert it into the Asset table. However I would like to continue to display the description as I move to other fields on the form. I was able to use a sub form to display the info but think there must be a better way. Any Ideas?

 

[pbaldy]

One way:

http://www.baldyweb.com/Autofill.htm

 

[Larsporsenna]

Thanks, it worked fine.

 

[pbaldy]

No problem.