Access Append Query

[Kary]

I have a table to register organization names (Org) and a related table
(Area) to store the area's where these organizations operate. When a new
Organization is registered, the area(s) they work in are set.
My form collects the field "Area". On exit from this field on the form I
would like to use the "Area" in the criteria field of my APpend Query. Is
this possible?

 

[Ken Snell [MVP]]

Why use an append query? A form / subform design will do that for you
automatically. The main form would be bound ot the Org table, and the
subform would be bound to the Area table. As the user enters data in either
form or subform, the corresponding table is automatically updated.

If for some reason you don't want to use form / subform, tell us how your
form is structured so that it allows you to enter new Org and the Area info.