While the code is hanging you might want to check out the locks on the subscription table to see if something else is blocking it.

If you use the format() function you should be able to get just the date out.

Ex.

sDate = format("12/07/05 16:32", "mm/dd/yy")

You could do a find on the form's recordset using the pk of the new record that was just added. That'll probably work. As to the record being...

Would you mind posting the code that creates the recordset?

If you want to get the Common controls in the reference when it is not showing, you just need to hit the browse button and then navigate to where the...

Can you give me a brief explanation of what the code behind the "Add Like" button looks like. I don't need the exact code, but just kind of what...

Well, you can look up the specs on the tiff format and try to locate which parts of the file contain what you're looking for. I looked at this...

Just curious, how many records is your form loading?

Give this a try

db.execute sql, dbseechanges