Automatically Change the First Record in a Query

[Colin_S]

Hello,

I have a query which i need to help automatically changing.

I would like to automatically update the yes/no field in a query to yes.
Image of query below.

http://www.smithspace.co.uk/Query.JPG

What i finally want is a macro which will tick the first line, preform some
actions on it, remove it from the list and then tick the next line (whihc
will become the first line in the list as the previous first line will have
been removed) If i can get a query to lick the first line i have no problme
with the rest.

Please Help.

Many Thanks

Colin

 

[Colin_S]

forgot to say i only want the query to update the first line.