Appending all records

[Danu]

Hi -

From a "menu" users can choose the region they work. A form opens and
filters records for that region from a table which contains all the regions.
There can be several people pulling records from this main table but
different regions. Once they have done the work needed for each record, the
record is then appended to yet another table using a command button which
updates the master table. The command button initiates an append query. The
problem is that each time someone hits the "append" button, ALL records
matching the criteria regardless of the region get appended. How can I limit
the records being appended to just the region the user is working? I'd like
to be able to use just the one append query and somehow limit the region
being updated or should I create an append query for each region?

All help is appreciated. Thank you.

 

[Maurice]

This depends. Do you have a split database or are the users all sharing the
same database. In case of the latter you will always have problems with
several options using the same append query.

When you have a split db you can create an appendquery for each user because
they will have their own frontend. In that case you can reference the
combobox in the appendquery something like:


in the criteria from the regionfield of the query place:
forms!frmname!cboRegion

and then you'd have to figure out what to do if people don't choose a region
and do click the commandbutton.. etc.

 

[Danu]

Hi, Maurice -

Yes, all users are sharing the same database. So, in this case, would you
recommend a separate append query for each region to append to the same
master table?

Thank you!

 

[Maurice]

That could be an option but it will also mean a lot of maintenance. What if
there's a new region? You'd have to create a new query for every added
region. But i guess you are stuck because you are still working in one not
split db. Give it a try and consider splitting the db that will give you more
flexability..