Hi All
I want to avoid updating the entire table when running a query.
Basically the front page form of my DB is a series of drop down lists which populate a table, thats easy.
When the user has chosen each drop down field I ask them to press a command button which runs a query that adds (&) all their choices for the specific record into the nominated column, I have completed this sucessfully...
However, it performs the query on every record in the table and after a while, when the DB is large, I suspect this would become a little difficult to handle.
My thoughts are it should be a criteria statement limiting it to work on only the last record but Im unsure of the expression to use...
Any thoughts??
Thanks