A
Ana
I had this question:
I have a form called POP form that uses data from a table BnkPtnr Table. I want to be able to select the BnkPtnr # (ID for bank partner) from a popup list in POP form and have the corresponding BnkPtnr Name automatically appear on the following field BnkPtnr Name (without having to type it). BnkPtnr Table has two fields ID and Name.
And this was the solution given to me:
You need a combo box with 2 columns, one for BnkPtnr # and one for BnkPtnr Name. You can do this with a Table/Query row source type and have the Row Source to select the 2 fields.
Row Source:
SELECT [BnkPtnr Table].[BnkPtnr #], [BnkPtnr Table].[BnkPtnr Name] FROM [BnkPtnr Table] GROUP BY [BnkPtnr Table].[BnkPtnr Name], [BnkPtnr Table].[BnkPtnr #] ORDER BY [BnkPtnr Table].[BnkPtnr Name];
Your Bound Column should be 1
Your Bank Partner Name text box control source should be: =cboBnkPtnrNum
the cboBnkPtnrNum is what I named a combo box Bank Partner Number.
However, I know I'm doing something wrong b/c I am still stuck. Here's what I did:
I set all the combo box info above into field name BnkPtnr # on my POP form. Then I set the control source on BnkPtnr Name field on my POP form to cboBnkPtnrNum. However, I don't know how to assign cboBnkPtnrNum = BnkPtnr # so I get an error #name? on the BnkPtnr Name field in POP form. I also tried to set the control source to BnkPrtnr# but then I get the bank partner number displayed rather than the bank partner name.
Can someone help me?
Thx.
Ana
I have a form called POP form that uses data from a table BnkPtnr Table. I want to be able to select the BnkPtnr # (ID for bank partner) from a popup list in POP form and have the corresponding BnkPtnr Name automatically appear on the following field BnkPtnr Name (without having to type it). BnkPtnr Table has two fields ID and Name.
And this was the solution given to me:
You need a combo box with 2 columns, one for BnkPtnr # and one for BnkPtnr Name. You can do this with a Table/Query row source type and have the Row Source to select the 2 fields.
Row Source:
SELECT [BnkPtnr Table].[BnkPtnr #], [BnkPtnr Table].[BnkPtnr Name] FROM [BnkPtnr Table] GROUP BY [BnkPtnr Table].[BnkPtnr Name], [BnkPtnr Table].[BnkPtnr #] ORDER BY [BnkPtnr Table].[BnkPtnr Name];
Your Bound Column should be 1
Your Bank Partner Name text box control source should be: =cboBnkPtnrNum
the cboBnkPtnrNum is what I named a combo box Bank Partner Number.
However, I know I'm doing something wrong b/c I am still stuck. Here's what I did:
I set all the combo box info above into field name BnkPtnr # on my POP form. Then I set the control source on BnkPtnr Name field on my POP form to cboBnkPtnrNum. However, I don't know how to assign cboBnkPtnrNum = BnkPtnr # so I get an error #name? on the BnkPtnr Name field in POP form. I also tried to set the control source to BnkPrtnr# but then I get the bank partner number displayed rather than the bank partner name.
Can someone help me?
Thx.
Ana