Question on Update Query

[dvannoy]

I have a form that brings up documents with info about them.

The form is based off a query with this as the criteria:

Like * & [Enter Doc# Below] & *

Our doc#'s have "-1a" "-1b" etc..

Now I created a button that runs an update query and stamps date and a couple of other things. The criteria for the update query is:

Form![FormName]![Doc#]

it works fine, but it will only update the first record.

How can i add the Like statement or have it stamp on the records the form pulled up.?


Thanks in advance


DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[THoey]

I think your query is just updating the current record. Base your update query on the same criteria as you use to select the records to display on the form. This should update them all. Terry M. Hoey

 

[dvannoy]

I am having a hard time setting the criteria.. DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[THoey]

You should be able to take your select query, change it to an update query and then save it off as a new name. Please post your code that is not working here and we can take a look at it... Terry M. Hoey