Ksabai

[Ksabai]

Hello Everyone,

I'm an novice to ms access. I have tables contract and payments. In Form Payments iam trying to call a condition from contract table to enable or disable the field. my code looks like this but not working:

Private Sub Form_Current()
If (Me.[Contract].[Payment Terms] = "Cash") Then
Me.CADAdvValue.Enabled = False
Me.CADAdvDate.Enabled = False
Else
Me.CADAdvValue.Enabled = True
Me.CADAdvDate.Enabled = True
End If

I get the error unable find field. pls help.

 

[Gasman]

You use the form control not the table fields, so something along the lines of
Me.paymentControl or whatever you have called it.

HTH

 

[Ksabai]

Can u please advice a code for me. iam unable to figure out a code.

 

[Ksabai]

Tried as follows, does not work

If Me.Contract.Payment Terms = "Cash" Then

 

[Ksabai]

Iam getting the error saying that table tblcontract cannot be found. i tried as follows

Me.Contract.Payment_Terms.Value = "Cash"

 

[Gasman]

You need to look to see what the contral name is.
If you built the form from the table and the table is Contract and the field is Payment_Terms then it would be

Me.Payment_Terms = "Cash"

HTH

 

[Ksabai]

Gasman, this works if Payment_Terms is in same Table as the form. here the Payment_Terms is in the Table.Contract and the Form Record.Source is from Table Payment.

Iam trying to get the detail from an other table

REgards