Using the look up wizard and combo box

[Guest]

Hi
I really need some help, i have created a database for our farm and it has
become quite complex and im very stuck. I have a combo box which allows you
to select a medicine and i want to have it so that clicking and choosing your
medicine then means the withdrawel date which is in the same table as the
medicine name goes into a different box on the same form. I have tried but it
comes up with an error and i can't get it to work. please help!!!!

 

[John Vinson]

Hi
I really need some help, i have created a database for our farm and it has
become quite complex and im very stuck. I have a combo box which allows you
to select a medicine and i want to have it so that clicking and choosing your
medicine then means the withdrawel date which is in the same table as the
medicine name goes into a different box on the same form. I have tried but it
comes up with an error and i can't get it to work. please help!!!!

You'ld need some sort of code in the AfterUpdate event of the combo.
Since we cannot see your form, and know nothing about your field or
control names, it's impossible for us to give specific advice. Could
you perhaps post the name of the Form and of the relevant controls,
and perhaps also your code and the errors you're getting?

John W. Vinson[MVP]