Current Record in history (1 Viewer)

Thumper75

Registered User.
Local time
Yesterday, 23:34
Joined
Feb 6, 2017
Messages
37
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

Well-known member
Local time
Today, 00:34
Joined
Apr 9, 2015
Messages
4,339
the query in the subform should exclude the current master record....

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

Users who are viewing this thread

Top Bottom