Hi Forum,
I have a table tblAccounts, with TransID (Autonumber,PK), TransAccount (text), TransDate, TransTime (Text with 4 chars 0000 - 2300 format), TransAmount, TransStatus (Active or In Active).
In an unbound form I have created a text box (Text1) with multi line enabled for entering Account Numbers. What i am trying to achieve is;
1. Look Account Numbers entered in Text1 in tblAccount[TransAccount]
2. If found, look for LAST entry (with TransDate+TransTime), not for DLast
3. If Last Entry Status field is "In Active", then copy ONLY those account numbers form Text1 to another text box (Text2)
4. If possible Delete Text2 Account numbers from Text1, so only Active accounts will be in Text1.
Thank you for your help.