I am having 2 problems with the attached sample cash bookthat I am working on. It does not show the ID Card No. When I Select the LabourDaily Wages in the Account Head and Then Name of The Worker in Description,where as the rest of the descriptions are updated.
The combo “Perticulars” does not show the value of column2, and after update it does not update the value of column 2 in the field “DBKNic”.
Combo Box “A/C Head”
SELECT [DBKHeads&Items].[DBKHHead] FROM[DBKHeads&Items] GROUP BY [DBKHeads&Items].[DBKHHead];
Combo Box “Perticulars”
SELECT [DBKHeads&Items].DBKHItems,[DBKHeads&Items].DBKHNICNo FROM [DBKHeads&Items] WHERE((([DBKHeads&Items].DBKHHead)=[forms]![DBKCashBook].[A/C Head])) GROUP BY[DBKHeads&Items].DBKHItems, [DBKHeads&Items].DBKHNICNo;
After update properties of “Perticulars”
Private Sub Perticulars_AfterUpdate()
Me.DBItmDesc = Me.Perticulars.Column(0)
Me.DBKNic = Me.Perticulars.Column(1)
Me.Refresh
End Sub
I could not locate the mistake am doing, a help in fixingthis problem would be highly appreciated.
A sample is attached.
Sample.zip