i'm using access as front end and mysql as back end. i have a code that's updating a certain field for a specific record, the problem is that after updating i want to refresh or requery (that's the term in ms access) my record source so that it will also refresh my form to see the updated field. i tried using the command Requery but it didn't work. is there an equivalent command in mysql of requerying data? i'm not very familiar with mysql, hope somebody could help me.