select multiple rows one at a time and update a field (Access)

M

Michael-G

I have a table that I need to selectively update a given row. I have written
a query that will prompt for the key for the row I want. I now want it to
prompt me for the data to update "fieldx" on that row, update it and then
prompt me for the next key. When I am finished, I want to enter "null".

I'm kind of new with this so any suggestions?
 
J

John W. Vinson

I have a table that I need to selectively update a given row. I have written
a query that will prompt for the key for the row I want. I now want it to
prompt me for the data to update "fieldx" on that row, update it and then
prompt me for the next key. When I am finished, I want to enter "null".

I'm kind of new with this so any suggestions?
Click to expand...

Update queries - and queries in general - work better in an "all at once" way
rather than step by step. What is the actual structure of your table? Are you
prompting the user for which *field* to update? If so, I have to wonder if
your table structure is correctly normalized.

If you're just updating a single table, the simplest way might be to base a
Form on the table; put a combo box on the form (using the combo toolbox
wizard) to find a record. Then the user can simply update the field. No need
for any query or any code (other than the wizard-generated combo box code).

John W. Vinson [MVP]
 
Top