Update query for current record only

[goslincm]

Hi, I have a series of 10 update queries that I need to run upon completion of a form's data entry. Currently when it runs its updating all records, but at this point I only need the queries to update the current record. How do I tell each query to only update the current record that was input?

 

[dhookom]

You could probably set the criteria in the update query to something like:

Forms![Name of Current Form]![Name of Primary key Field]

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[goslincm]

So how would that look in this query given the primary key field is AUTONO and the form name is REVIEW

INSERT INTO AUDITRPT_RESPONSE ( AUTONO, QUESTION_YN, QUESTION_NUM )

SELECT [AUDIT REVIEWS].AUTONO, [AUDIT REVIEWS].[05-10], "3" AS QUESTION_NUM

FROM [AUDIT REVIEWS];

 

[dhookom]

btw: this is an append query, not an update query.
Try something like:

INSERT INTO AUDITRPT_RESPONSE ( AUTONO, QUESTION_YN, QUESTION_NUM )

SELECT [AUDIT REVIEWS].AUTONO, [AUDIT REVIEWS].[05-10], "3" AS QUESTION_NUM
FROM [AUDIT REVIEWS]
WHERE [AUTONO] = Forms!Review!AUTONO;

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[goslincm]

Thanks that works good.