Eljefegeneo
Still trying to learn
- Local time
- Yesterday, 22:23
- Joined
- Jan 10, 2011
- Messages
- 902
I have a combox field called ClientID. The row source for this field is
To enter a new record I merely type in the ClientID and the first eight fields populate the form with the
after update event:
But I cannot get the ninth and tenth fields to populate. The last three are Y/N. If I switch field #9 for Field #8 in the above SQL statement, and then change the number of the column in the after update event, the field populates, that is, there is nothing wrong with the field and its data.
So my question is why won't the ninth and tenth columns populate the form? Is there some sort of limit?
Code:
SELECT tblCustomerMaintenance.ClientID, tblCustomerMaintenance.Contact, tblCustomerMaintenance.Organization, tblCustomerMaintenance.ProgramTitle, tblCustomerMaintenance.Address, tblCustomerMaintenance.CityState, tblCustomerMaintenance.ZipPC, tblCustomerMaintenance.Country1, tblCustomerMaintenance.Caution, tblCustomerMaintenance.Einv, tblCustomerMaintenance.ACH
FROM tblCustomerMaintenance
ORDER BY tblCustomerMaintenance.ClientID;
after update event:
Code:
Client = ClientID.Column(1)
Organization = ClientID.Column(2)
ProgramTitle = ClientID.Column(3)
Address = ClientID.Column(4)
CityState = ClientID.Column(5)
ZipPC = ClientID.Column(6)
Country = ClientID.Column(7)
Caution = ClientID.Column(8)
Einv = ClientID.Column(9)
ACH = ClientID.Column(10)
But I cannot get the ninth and tenth fields to populate. The last three are Y/N. If I switch field #9 for Field #8 in the above SQL statement, and then change the number of the column in the after update event, the field populates, that is, there is nothing wrong with the field and its data.
So my question is why won't the ninth and tenth columns populate the form? Is there some sort of limit?