accessNator
Registered User.
- Local time
- Today, 10:10
- Joined
- Oct 17, 2008
- Messages
- 132
Hello,
I have form which the Default View is set as Continuous Forms.
Its Record Source comes From tblBatchAmt
tblBatchAmt
Company_Id
Check_No
Amount
In the form, I added the three fields from tblBatchAmt, alongside of it is a combo box called cboQuickSearchById which the RowSource comes from a tblCompanyInformation
tblCompanyInformation
Reference_Id
Company_Id
Company_Name
Row Source:
Bound Column = 1
So what I am doing is displaying
cboQuickSearchById | Company_Id | Check_No | Amt
(txtId) (txtCheckNo) (txtAmount)
When I click on the cboQuickSearchById and search for an ID number, after update, it automatically populates my Company_Id field, this works great. But after I use the combo box, it creates another record below with the same row, but the combo box, reflects the same value as the first combo box. If I change either combo box, all other combo boxes change too. I want the combo boxes to be independent of each other for each record.
What am I doing wrong?
Thanks.
I have form which the Default View is set as Continuous Forms.
Its Record Source comes From tblBatchAmt
tblBatchAmt
Company_Id
Check_No
Amount
In the form, I added the three fields from tblBatchAmt, alongside of it is a combo box called cboQuickSearchById which the RowSource comes from a tblCompanyInformation
tblCompanyInformation
Reference_Id
Company_Id
Company_Name
Row Source:
Code:
SELECT tblCompanyInformation.Company_Id, tblCompanyInformation.Company_Name FROM tblCompanyInformation ORDER BY tblCompanyInformation.Company_Id, tblCompanyInformation.Company_Name;
Bound Column = 1
So what I am doing is displaying
cboQuickSearchById | Company_Id | Check_No | Amt
(txtId) (txtCheckNo) (txtAmount)
When I click on the cboQuickSearchById and search for an ID number, after update, it automatically populates my Company_Id field, this works great. But after I use the combo box, it creates another record below with the same row, but the combo box, reflects the same value as the first combo box. If I change either combo box, all other combo boxes change too. I want the combo boxes to be independent of each other for each record.
What am I doing wrong?
Thanks.