Help with Update Query

[RachelBedi]

I need to write an update query which takes records from a table and updates a particular field.



The only caveat to this is that I need a text box to allow the user to enter the number of random records they want to update. For example the form will show two text boxes and one button. One text box would show the number of records available to be assigned. The second text box would allow the user to enter the number of records they would like to have assigned to them(Ie. 10). The button would then run an update and fill in the "Assigned" field for the number of records entered (ie. 10)

Does anyone have any suggestions on how to execute?

[June7]

Consider: INSERT INTO tablename(fieldname) SELECT fieldname ....;

Options:

1. Build query that selects x number random records and that query is subquery to INSERT action.

2. Build query that selects 1 random record and that query is subquery to INSERT action. In VBA loop structure execute query as many times as specified by user.

Google: SQL select random record
http://www.cosnetics.co.uk/articles/...s-from-access/