auto fill using combo box

[titan]

Hello,
I just had help creating a form that searches and it works. now im stuck on
trying on I am trying to use a data entry form that has a drop down combo
box. when i select from that list, I would like another field, that is next
to it come up with a description of what that combo box information
represents. the combo box information and the description is information
coming from the same table.

Please help if you can.

I appreciate it very much

titan

 

[Al Camp]

Titan,
Make your combo a 2 column combo by adding that Description field to the
query behind the combo.
Then, on the AfterUpdate event of the combo... (use your own names)
[MyFormDescField] = cboYourComboName.Column(1)
(combo box columns are numbered 0, 1, 2, etc.. so the second column would be
Coulumn(1))
hth
Al Camp

 

[titan]

Hello,
I added the new description field to the query behind the combo. then on
After update I typed in the destination of the field on the form = cbo with
the name of the combo box.Column(1). and after saving it, I got an error
stating that it cant find the macro [name of filed destination on current
form]=cboNameofcombobox. I am typing it out with these descriptive names
just so I know that I understood what you told me to do. If I misread your
instructions or if you have further advice I would apprecite the help.

thank you in advance

titan

Titan,
Make your combo a 2 column combo by adding that Description field to the
query behind the combo.
Then, on the AfterUpdate event of the combo... (use your own names)
[MyFormDescField] = cboYourComboName.Column(1)
(combo box columns are numbered 0, 1, 2, etc.. so the second column would be
Coulumn(1))
hth
Al Camp

Hello,
I just had help creating a form that searches and it works. now im stuck
on
trying on I am trying to use a data entry form that has a drop down combo
box. when i select from that list, I would like another field, that is
next
to it come up with a description of what that combo box information
represents. the combo box information and the description is information
coming from the same table.

Please help if you can.

I appreciate it very much

titan

 

[titan]

It worked, I was doing something wrong but I fixed it, thanks for the help

titan

Hello,
I added the new description field to the query behind the combo. then on
After update I typed in the destination of the field on the form = cbo with
the name of the combo box.Column(1). and after saving it, I got an error
stating that it cant find the macro [name of filed destination on current
form]=cboNameofcombobox. I am typing it out with these descriptive names
just so I know that I understood what you told me to do. If I misread your
instructions or if you have further advice I would apprecite the help.

thank you in advance

titan

Titan,
Make your combo a 2 column combo by adding that Description field to the
query behind the combo.
Then, on the AfterUpdate event of the combo... (use your own names)
[MyFormDescField] = cboYourComboName.Column(1)
(combo box columns are numbered 0, 1, 2, etc.. so the second column would be
Coulumn(1))
hth
Al Camp

Hello,
I just had help creating a form that searches and it works. now im stuck
on
trying on I am trying to use a data entry form that has a drop down combo
box. when i select from that list, I would like another field, that is
next
to it come up with a description of what that combo box information
represents. the combo box information and the description is information
coming from the same table.

Please help if you can.

I appreciate it very much

titan

 

[Al Camp]

titan,
My combo name... cboYourComboName was just an example. If the name of
your combo was [XYZ]
then = XYZ.Column(1) would be correct. You may have thought Access
requires the "cbo".
I see you're all set now... good deal.
Al Camp

Hello,
I added the new description field to the query behind the combo. then on
After update I typed in the destination of the field on the form = cbo
with
the name of the combo box.Column(1). and after saving it, I got an error
stating that it cant find the macro [name of filed destination on current
form]=cboNameofcombobox. I am typing it out with these descriptive names
just so I know that I understood what you told me to do. If I misread
your
instructions or if you have further advice I would apprecite the help.

thank you in advance

titan

Titan,
Make your combo a 2 column combo by adding that Description field to
the
query behind the combo.
Then, on the AfterUpdate event of the combo... (use your own names)
[MyFormDescField] = cboYourComboName.Column(1)
(combo box columns are numbered 0, 1, 2, etc.. so the second column would
be
Coulumn(1))
hth
Al Camp

Hello,
I just had help creating a form that searches and it works. now im
stuck
on
trying on I am trying to use a data entry form that has a drop down
combo
box. when i select from that list, I would like another field, that is
next
to it come up with a description of what that combo box information
represents. the combo box information and the description is
information
coming from the same table.

Please help if you can.

I appreciate it very much

titan

 

[Tony F]

Hello Al
I used the method below and got the error message "Compile Error:Method or
data member not found" with the full stop and the word column following it
highlighted when I selected an item in the combo box.
I'm using Access 2000.
Can you tell me what I might be doing wrong?

Many thanks

Tony F.

Titan,
Make your combo a 2 column combo by adding that Description field to the
query behind the combo.
Then, on the AfterUpdate event of the combo... (use your own names)
[MyFormDescField] = cboYourComboName.Column(1)
(combo box columns are numbered 0, 1, 2, etc.. so the second column would be
Coulumn(1))
hth
Al Camp

Hello,
I just had help creating a form that searches and it works. now im stuck
on
trying on I am trying to use a data entry form that has a drop down combo
box. when i select from that list, I would like another field, that is
next
to it come up with a description of what that combo box information
represents. the combo box information and the description is information
coming from the same table.

Please help if you can.

I appreciate it very much

titan