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.

thanks