Append only present record

  • Thread starter Thread starter an
  • Start date Start date
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.
 
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.
 
Back
Top