Current Record in history

[Thumper75]

Hi all, I feel like a dope at the moment.

My form is returning the current record in the subform as history. Any idea's how to exclude the current record? I'm thinking a recordset count if any records are not equal to the LogPage #, but I can't think how to write it.

Suggestions?

 

[Ranman256]

the query in the subform should exclude the current master record....

select * from table where [keyID] <> forms!MasterForm!txtKeyID