|  | Combo box on form | | |
| | | Selby |  |
|  Posted: Tue Aug 26, 2008 3:24 pm Post subject: Combo box on form |  |
I am working on someone else's form. At the top of the form you can either
choose to look up information via an invoice number, bill of lading number or
pro number. When you do, the bottom of the form fills in the information
from an order info table.
I would like to add another choice to the top of the form - By Customer po #
- I have added the combo box and it will pull info, but it will not force the
rest of the form to fill in. I noticed that on the other three, there was an
event procedure on After Update - I copied in this code, but it still does
not work.
I am familiar with Access but this is over my head. Any suggestions? |
| |
| | | mick | |
| | Posted: Tue Aug 26, 2008 3:27 pm Post subject: RE: Combo box on form | |
What is the code ?
What is the name of the new combo box you have added - is it refered to in
the code
"Selby" wrote:
| Quote: | I am working on someone else's form. At the top of the form you can either
choose to look up information via an invoice number, bill of lading number or
pro number. When you do, the bottom of the form fills in the information
from an order info table.
I would like to add another choice to the top of the form - By Customer po #
- I have added the combo box and it will pull info, but it will not force the
rest of the form to fill in. I noticed that on the other three, there was an
event procedure on After Update - I copied in this code, but it still does
not work.
I am familiar with Access but this is over my head. Any suggestions? |
|
| |
| | | Selby | |
| | Posted: Tue Aug 26, 2008 3:58 pm Post subject: RE: Combo box on form | |
| |  | |
As I was pasting the code here I realized that I had not changed the combo
box number in all of the places from the code I had copied to the new combo
box. When I did that, it worked. Sorry for taking up your time. Thanks for
replying!
End If
"mick" wrote:
| Quote: | What is the code ?
What is the name of the new combo box you have added - is it refered to in
the code
"Selby" wrote:
I am working on someone else's form. At the top of the form you can either
choose to look up information via an invoice number, bill of lading number or
pro number. When you do, the bottom of the form fills in the information
from an order info table.
I would like to add another choice to the top of the form - By Customer po #
- I have added the combo box and it will pull info, but it will not force the
rest of the form to fill in. I noticed that on the other three, there was an
event procedure on After Update - I copied in this code, but it still does
not work.
I am familiar with Access but this is over my head. Any suggestions? |
|
| |
| | | Ramona | |
| | Posted: Wed Aug 27, 2008 2:20 pm Post subject: Re: Combo box on form | |
"mick" <mick@discussions.microsoft.com> skrev i nyhetsmeldingen:
44413056-0EF9-4901-8A93-A544CC1FFE67@microsoft.com ...
| Quote: | What is the code ?
What is the name of the new combo box you have added - is it refered to in
the code
"Selby" wrote:
I am working on someone else's form. At the top of the form you can
either
choose to look up information via an invoice number, bill of lading
number or
pro number. When you do, the bottom of the form fills in the information
from an order info table.
I would like to add another choice to the top of the form - By Customer
po #
- I have added the combo box and it will pull info, but it will not force
the
rest of the form to fill in. I noticed that on the other three, there
was an
event procedure on After Update - I copied in this code, but it still
does
not work.
I am familiar with Access but this is over my head. Any suggestions? |
|
| |
|
|
