Append query that takes input from a form

M

mbs4653

I need to write an append query that prompts the user for input from
field but takes the input for all the other fields from a form.

I am not too sure how to do this, since it seems the append querie
only take input from tables or queries.

Any help greatly appreciated
 
L

Larry Linson

mbs4653 said:
I need to write an append query that prompts the user for input from 1
field but takes the input for all the other fields from a form.

I am not too sure how to do this, since it seems the append queries
only take input from tables or queries.

Any help greatly appreciated.
Click to expand...

I am puzzled as to why you would NEED two different means of collecting
information from the user -- could you clarify?

It seems to me that I have worked with unbound Forms used for data input
which created the SQL for an Append Query, including the Values to be
Appended, and ran the query. It is possible that I mis-remember, but I
believe that to be the case.

Larry Linson
Microsoft Access MVP
 
Top