Hi
I have a combo box, that I set up with the wizard, that is entering the wrong value into the designated field of the destination table.
The combo box is on a form--frmAccountsInputEdit--used to enter a new bank account into a table named tblAccounts containing two fields: [accountsBank], [accountsName], [accountsNumber] and an autonumber key field
I want the combo box to enter, into tblAccounts the value for the [accountsBank] field based on values in another table - tblBank
tblBank has an autonumber field as the key.
I want to use, from tblBank, the field [bankName]
So, a value from [tblBank].[bankName] would end up in [tblAccounts].[accountsBank]
The problem is that instead of that value, what is being entered is the value of the key field from tblBank
There are no lookup fields in either of the tables and I am using the wizard as I have always done.
Relevant info from the form frmAccountsInputEdit is:
Control Source - accountsBank
Row Source - SELECT [tblBank].[ID], [tblBank].[bankName] FROM tblBank ORDER BY [bankName];
Row Source Type -Table/Query
Bound Column -1
I'm not a sophisticated user of Access but I have used the wizard to make many combobox controls and have never had a problem. Would really appreciate any help you could provide.
I have a combo box, that I set up with the wizard, that is entering the wrong value into the designated field of the destination table.
The combo box is on a form--frmAccountsInputEdit--used to enter a new bank account into a table named tblAccounts containing two fields: [accountsBank], [accountsName], [accountsNumber] and an autonumber key field
I want the combo box to enter, into tblAccounts the value for the [accountsBank] field based on values in another table - tblBank
tblBank has an autonumber field as the key.
I want to use, from tblBank, the field [bankName]
So, a value from [tblBank].[bankName] would end up in [tblAccounts].[accountsBank]
The problem is that instead of that value, what is being entered is the value of the key field from tblBank
There are no lookup fields in either of the tables and I am using the wizard as I have always done.
Relevant info from the form frmAccountsInputEdit is:
Control Source - accountsBank
Row Source - SELECT [tblBank].[ID], [tblBank].[bankName] FROM tblBank ORDER BY [bankName];
Row Source Type -Table/Query
Bound Column -1
I'm not a sophisticated user of Access but I have used the wizard to make many combobox controls and have never had a problem. Would really appreciate any help you could provide.