entering parameters from combo box

[Dave the Nav]

I am building a database to track Grants for a state office. When the grant
arrives the basic information is entered into a table (via a form). After a
panel considers the grant it is either approved or disapproved. If approved,
the basic information needs to be parsed and then appended to three other
tables (the working tables of the database. If disapproved, the basic
information is appended to the ddisapproved table. Then the record in the
basic information table is deleted. I would like to use a combo box (with
Grantee name) to select the record from the basic information table for
movement to the working tables or the disapproved table.

This is like a parameter query except for the combo box. Suggestions?

 

[John Vinson]

On Sun, 19 Jun 2005 07:47:02 -0700, Dave the Nav <Dave the

I am building a database to track Grants for a state office. When the grant
arrives the basic information is entered into a table (via a form). After a
panel considers the grant it is either approved or disapproved. If approved,
the basic information needs to be parsed and then appended to three other
tables (the working tables of the database. If disapproved, the basic
information is appended to the ddisapproved table. Then the record in the
basic information table is deleted. I would like to use a combo box (with
Grantee name) to select the record from the basic information table for
movement to the working tables or the disapproved table.

This is like a parameter query except for the combo box. Suggestions?

Short answer: you can use a criterion such as

=[Forms]![NameOfForm]![NameOfCombobox]

as a criterion, provided that the form is open. The form could have a
command button to launch the append queries.

Longer answer: storing the same data in three different tables is
probably not the best design! Rather than having separate tables for
pending grants, approved grants, and disapproved grants, you may want
to consider having a table of Grants, with fields for approval (such
as date approved, reason for disapproval, etc.); or (if necessary) a
one to one relationship to an Approvals table if you need additional
data for approved grants.


John W. Vinson[MVP]