add multiple records from a form into a table

[Green Biro]

I have a query, which gives me an "expected updates" list.

What I want to do is to present this on a form along with another field -
whcih can be edited by the user - and then append all records including the
extra field into another table.

The matter is also further complicated by the fact that there is a
possibility that some records already exist in the destination table so I
need to check their existence first and just update these records rather
than append them.

Can anyone give me any pointers on how to set about this please?

Thanks

GB

 

[Mike Painter]

I have a query, which gives me an "expected updates" list.

What I want to do is to present this on a form along with another
field - whcih can be edited by the user - and then append all records
including the extra field into another table.

The matter is also further complicated by the fact that there is a
possibility that some records already exist in the destination table
so I need to check their existence first and just update these
records rather than append them.

Can anyone give me any pointers on how to set about this please?

Thanks

Present what on a form?
Append what records?
What do you mean by "extra field"

 

[Green Biro]

I think that I'm nearly there.

I meant that I wanted to have my query of 'expected updates' as the source
to a form. I want to add these records with one more field into another
table.

I've changed my 'expected updates' query into a maketable query and added a
blank field.
After a couple more steps, I should be able create an append query from my
temporarily made table.

Thanks for your interest.

GB