B
BobbyDazzler
tblCustomer
custid PK autonumber
custname text
custcode text
custacct yes/no
used in frminvoice as combobox using all 4 fields (custid hidden)
example data in combobox
A D Plumbers | AD0001 | -1
Smith, Andrew | SM0001 | 0
column(3) either shows -1 for true or 0 for false
This field indicates whether the customer is an account holder or not,
if they are then txtsaletype should read "CREDIT SALE" and if they
aren't it should read "CASH SALE"
Once a customer is selected from the drop down list I have this code
running in the afterupdate event:-
If Me!cboSelect.Column(3) = -1 Then
Me!chkCustomerAcctHeld = -1
Else
Me!chkCustomerAcctHeld = 0
End If
If Me!chkCustomerAcctHeld = -1 Then
txtsaletype = "CREDIT SALE"
Else
txtsaletype = "CASH SALE"
End If
It doesn't work! Where am I going wrong?
Thanks
David
custid PK autonumber
custname text
custcode text
custacct yes/no
used in frminvoice as combobox using all 4 fields (custid hidden)
example data in combobox
A D Plumbers | AD0001 | -1
Smith, Andrew | SM0001 | 0
column(3) either shows -1 for true or 0 for false
This field indicates whether the customer is an account holder or not,
if they are then txtsaletype should read "CREDIT SALE" and if they
aren't it should read "CASH SALE"
Once a customer is selected from the drop down list I have this code
running in the afterupdate event:-
If Me!cboSelect.Column(3) = -1 Then
Me!chkCustomerAcctHeld = -1
Else
Me!chkCustomerAcctHeld = 0
End If
If Me!chkCustomerAcctHeld = -1 Then
txtsaletype = "CREDIT SALE"
Else
txtsaletype = "CASH SALE"
End If
It doesn't work! Where am I going wrong?
Thanks
David