Reference table field in Event Procedure

[Len Boorman]

I have a table with a single field that will only ever have one record.
Basically sequence is
All rows deleted
Series of queries run that result in the total number of duplicates found appended.(So there is only ever one row. Value may be null or >0

I now want to run some code on the after update event of a field on a form.

The code will go something like

If Table.fieldvalue>0 then
MsgBox etc
Else
End if

I am a greenhorn when it comes to figuring out how to reference the value of a field within a table.

Assistance appreciated

Len B

 

[MattS]

Would DLookUp suffice? If there's only ever one record, simply leave the criteria out:

DLookUp("FieldName","TableName")

HTH,

Matt.

 

[Len Boorman]

Hi Matts

Looks good

Thanks

Len B