Combo Box

[kmp]

I have a form with a combo box that lists an acct # and acct description. When you select the account number in the form field, I would like the acct description to automatically fill in another field. I tried to use a dlookup function but I think there might be more that I need to do. Any suggestions?

Thanks,

kmp

 

[DBL]

Base your form on an underlying query and add the two tables that you need, the one for the main form and the one that gives you the descriptions for the Acct#. Link the tables by the acct#. In design view of the form add the decription field from the second table to the form. Then, when you select the Acct# from the combo box, the related description should appear in the description field.

 

[kmp]

I am not sure if I understand exactly what it is that I need to do. Do I have to start over and design a new form or can I use the form that I have already designed?

I set up a query like you said and started a new form based on the query. The acct description comes in automatically based on data that was entered into the "old" form and it doesn't allow me to enter new records.

I think I must be doing something wrong. Please advise.

 

[Oldsoftboss]

To do as DBL suggests you almost have to start again. Is the field you are trying to fill ever going to be edited ? If not, try the download at this link
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=36863

I can email you the complete sample if you like (too large to post here)
Hope it has some ideas for you
Dave

 

[kmp]

Thanks so much for the link. It helped me out tremendously. I was able to get the field in my form to fill in automatically.

Thanks again!