Hello. I would appreciate some help in trying to solve this problem. I apologize if I have not been too clear.
My db has a form with a combo, a list box and two tables.
The combo is used as query criteria and has it's record source in tbl1
Tbl1 has has three fields: Codes, Prefix and Countries.
Examples of Codes are 00, 11, 22, 33
Example of Prefix: A, B, C
Examples of Countries are USA, UK and France
Some Countries may have a similar Code, reason why there is a Prefix.
Tlb2 has two fields: Accounts and Branch
After users select the Code in the combo, the listbox returns all records from tbl2 that show the first two digits in Accounts similar to the query criteria:
Example: Selection in combo: 00
Listbox: Returns all records that show in field Accounts the first two digits 00
As I previously said, there may be multiple records with the same Accounts and would like to be able to determine the Country.
I was thinking of associating to the click event of the listbox a code that will specify the Country (probably in a txtbox or label) through the Prefix.
Example:
Combo selection: 00
Listbox:
Record1: Account 0011111 Branch: A132 (txtbox/label should show Country Name based on prefix)
Record2: Account 0011111 Branch: B321
Record3: Account 0011111 Branch: C000
Thank you
My db has a form with a combo, a list box and two tables.
The combo is used as query criteria and has it's record source in tbl1
Tbl1 has has three fields: Codes, Prefix and Countries.
Examples of Codes are 00, 11, 22, 33
Example of Prefix: A, B, C
Examples of Countries are USA, UK and France
Some Countries may have a similar Code, reason why there is a Prefix.
Tlb2 has two fields: Accounts and Branch
After users select the Code in the combo, the listbox returns all records from tbl2 that show the first two digits in Accounts similar to the query criteria:
Example: Selection in combo: 00
Listbox: Returns all records that show in field Accounts the first two digits 00
As I previously said, there may be multiple records with the same Accounts and would like to be able to determine the Country.
I was thinking of associating to the click event of the listbox a code that will specify the Country (probably in a txtbox or label) through the Prefix.
Example:
Combo selection: 00
Listbox:
Record1: Account 0011111 Branch: A132 (txtbox/label should show Country Name based on prefix)
Record2: Account 0011111 Branch: B321
Record3: Account 0011111 Branch: C000
Thank you