ComboBox - Continuous Forms Problem

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:
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.
 

Users who are viewing this thread

Back
Top Bottom