Append Query Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an append query that will add a new record and insert an itemno - I am
having trouble with the criteria. I run it from a form that is filtered like
this:

[Requisition]![Department]=[Forms]![SelectOut]![Combo8]

The query appends the entire other table instead of just the filtered itemno.

Can you help me please?

Thanks in advance.
 
I have an append query that will add a new record and insert an itemno - I am
having trouble with the criteria. I run it from a form that is filtered like
this:

[Requisition]![Department]=[Forms]![SelectOut]![Combo8]

The query appends the entire other table instead of just the filtered itemno.

Can you help me please?

Thanks in advance.
Click to expand...

The fact that the Form is filtered is totally irrelevant to whether
the Query is filtered. The form is one thing, the query is a different
thing!

Use the Forms! etc. reference on the Criteria line of the append
query.

If you're doing so, or if this doesn't make sense, please post the
entire SQL view of your append query.

John W. Vinson[MVP]
 
Thanks John, I stayed up and hacked on it last night and got it.

Appreciate the help.

John Vinson said:
I have an append query that will add a new record and insert an itemno - I am
having trouble with the criteria. I run it from a form that is filtered like
this:

[Requisition]![Department]=[Forms]![SelectOut]![Combo8]

The query appends the entire other table instead of just the filtered itemno.

Can you help me please?

Thanks in advance.
Click to expand...

The fact that the Form is filtered is totally irrelevant to whether
the Query is filtered. The form is one thing, the query is a different
thing!

Use the Forms! etc. reference on the Criteria line of the append
query.

If you're doing so, or if this doesn't make sense, please post the
entire SQL view of your append query.

John W. Vinson[MVP]
Click to expand...
 
Back
Top