append query condundrum

[joolsUK0575]

OK trying my best to figure out an append query but having little luck

Hopefully can explain what I am after.

I have a main form that has a number of fields two of which I need to match up in a where condition: ref and ryear.

On this main form is a subform where the data from the append query will be pasted into.

I need to match the two fields on the main form (ref and ryear) to the ref and ryear fields contained within the query. Once the query has been run it will then append append the record/ s in to the subform.

In the append query itself I have three like conditions

1) Like ref
2) Like ryear
3) Like plot number

I would like to remove (1) and (2) from the query using a where condition but can not figure out how.

I am familiar using a where condition on a form to open up another form and I trying to do this with the append query. I don't want to open up another form with the query behind it.

Hope this makes sense

Jools

 

[neileg]

Hope this makes sense

Nope!

Forms don't have fields, only tables and queries. Forms can have text boxes that are bound to fields. However I suspect you have unbound text boxes where you are holding some user input values, yes?

I don't understand what this means:

I would like to remove (1) and (2) from the query using a where condition but can not figure out how

If you don't want these fields in the query, then don't have them in! Or do you mean that you want to filter on these fields by not have them show in the results? Or what?

More info please. Some sample data wouldn't hurt.