Running select and append queries to find data

[bamf]

I want to be able to run a macro from a command button that allows for a
specific data set to be found and then appended to a seperate table. I have
a central table that holds all info, and i want to ne able to type in
'surname' for example and access the relevant data set which wold then be
appended into a subsiduary table. Any help would be great!!!

 

[Duane Hookom]

How far have you progressed? Do you have an append query created? Do you
know how to add criteria to a query so that only specific records/rows are
returned from the query?

 

[bamf]

i am quite confident (i think) about writing the append tabel, to run from
the select query that hopefully will run earlier in the macro. It is the
selct query i am unsure of as the criteria for selection will be entered
manually when a record is being located. does this sound sensible?

 

[Duane Hookom]

I'm not sure how you expect users to select/filter records and why they
would append and keep duplicates.

Your questions are really vague so it is difficult to provide any
assistance.