Find or look up record

Originally Posted by Digitallad

I have a table with Coloms :

CardID : Timein : Bookstaken : Timeout : Booksback

When a person comes in his
card_id number is filled in to the field "cardid"
Time in = "now()"
Bookstaken is also filled in.
After update the form closes.
A couple of record can be made before the person leaves and give the books back.

I want to have a new form with a unbound text box which will search for the last record containing that specific Card Id number.
The rest of the record will then be filled in.
i.e.. Timeout = now()
I tried a number of "find" codes but none seems to work the way I want it to.

Originally Posted by Rabbit

An unbound text box can't really search for the last record containing a specific card id number. Unless you mean you want that unbound text box to concatenate every field in the record, which I doubt. So I'm thinking you want to return a specific field from the record.

Also, I assume the last record of a card id number will have the most recent Time In.

So, you'll want to use a DLookup to look up the field you want and a DMax as part of the criteria to get the last record.

Originally Posted by Digitallad

If I lookup the record will I be able to edit the rest of the blank records?
and what will the code look like?
I will see if I can work it out myself as well.
Thanks for the Info!!!

Originally Posted by Rabbit

I'm not following.

Are you trying to go to a certain record?
Or
Are you trying to retrieve a specific value from a table?