I have form which the Default View is set as Continuous Forms.
Its Record Source comes From tblBatchAmt
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
SELECT tblCompanyInformation.Company_Id, tblCompanyInformation.Company_Name FROM tblCompanyInformation ORDER BY
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?