check if true

[bunji]

I am trying get some fields filled in based on if a record's tick bock in a table is true.

This is my code

If DCount("[Based_Customer]", "tblACDetails", "[AC_Ser_No] = Forms![FrmAirFrame]![AC_SN]", True) Then

But i think this is the wrong formula, being half asleep can anyone help!!

 

[KenHigg]

If DCount("[Based_Customer]", "tblACDetails", "[AC_Ser_No] = '" & Forms![FrmAirFrame]![AC_SN] & "'", True) Then


???

 

[bunji]

Thanks for your reply however when i tried that i get a compile error, wrong number of arguments or invalid property assignment.

 

[KenHigg]

If DCount("[Based_Customer]", "tblACDetails", "[AC_Ser_No] = '" & Forms![FrmAirFrame]![AC_SN] & "'") > 0 Then

???

 

[bunji]

That worked thanks very much