Append Query Question

[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.

 

[John Vinson]

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.

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]

 

[Guest]

Thanks John, I stayed up and hacked on it last night and got it.

Appreciate the help.

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.

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]