sending unbound data along with Query

[Bladerunner]

I know it can be done but I cannot find it.

I have a query that appends a new record to a table called "tblMain". The tblprogeny I am querying does not have two fields the 'tblMain' has (Group and Location). By the mere nature of this type data, the value for both fields are static thus I did not include them on the data entry form for the tblProgeny. I would like to include them on the append query if I can. One field is "Group"with the static value at "Non-Active" and the other is "Location" where the static value is "Nursery"

I have tried to use the following expressions in the criteria field of each respective field slot of the query:

[tblgroup.group to tblmain.group] 'Where ([tblgroup.group]= "Non-Active")'

[tbllocation.location to tblmain.location] 'Where([tblLocation.Location]= "Nursery")' but it gives me an error that my syntax is not right? tblgroup.group to tblmain. anybody got any ideas.

Thanks ahead of time and have a nice day:>)

Bladerunner

 

[Bladerunner]

Open the querydef in design view and add two new columns. In the Field cell, put a reference to the form field.
Forms!myform!myfield
Access will prefix the field with something like "expr1:" to give it a name.
Then in the target cell put in the name of the column to append to..

Thanks it worked.


Bladerunner

 

[BugDog]

Thanks it worked.


Bladerunner

Worked for me too. Answered the question I joined the forum for and I didn't even have to ask it.

Thanks