Recent content by RAY-IT

Thanks, that's working brilliantly thank you and I had not understood the concept of linked tables so I don't need to do a refresh either :)

Yes there is an auto number but it doesn't matter about finding the latest one really, the intention is that there will only ever be one record in there and that will get deleted as soon as the value is copied to the user table. Well, I only want to do this if there isn't one in there already...

I have an access DB acting as a front end to MySQL using ODBC Linked Tables. It's for a python based clocking in system generating the records. I have a Staff Maintenance form that allows HR to update staff information including assigning a Fob ID. The Fob ID is unique and when scanned on a fob...