Append only present record

A

an

Hello!
In a Form, I have a command button to run an Appendquery.
When run it, the query append all records but I would like
to add only modify records, without save another records
without modification.

Q:
Is it possible add/append only present record of form, in
Access2K?

Thanks in advance.
 
R

Rick B

Yes, in your append query you specify which records to pull. Just have it
specify the record in the form. You would have to find a unique field (like
Ref# or Customer# or similar) and put the criteria in your query. It would
look something like...

=[Forms]![SomeFormNameHere]![SomeUniqueFieldNameHere]


Rick B

Hello!
In a Form, I have a command button to run an Appendquery.
When run it, the query append all records but I would like
to add only modify records, without save another records
without modification.

Q:
Is it possible add/append only present record of form, in
Access2K?

Thanks in advance.
 
A

an

Thanks for your reply.

Sorry but continue to add all records when I run
Appendquery...
an
 
Top