hi All,
I have a Dialog Form "Dialog Freight Invoice Selective Consignment-Client" having two unbound controls.
On first control "cmbConsignmentNo" After Update is:
Private Sub cmbConsignmentNo_AfterUpdate()
Me.cmbClientCIN.RowSource = "SELECT DISTINCT Clients.ClientCIN, Clients.ClientName " & _
"FROM CollectionVoucher INNER JOIN Clients " & _
"ON Clients.ClientCIN = CollectionVoucher.ClientCIN " & _
"WHERE CollectionVoucher.ConsignmentNo = '" & Nz(Me.cmbConsignmentNo, "") & _
"' ORDER BY Clients.ClientCIN"
End Sub
~~~~~~~~~~~~~
On the second control "cmbClientCIN" along with ClientCIN, ClientName I need to displayfield "ConsigneeName"
from the table "Consignee" having PK "ConsigneeID".
Table "CollectionVoucher" has the field "ConsigneeID".
How can the above After Update event be modified to display "ConsigneeName" in combox box ""cmbClientCIN".
Need help for this.
Regards,
Khalid
Posted by: khalidtanweerburrah@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar