Form-Lookup Values, Yes/No Fields, Etc..

[Guest]

I know what I want to do, but I don't know how to do it in Access!

Background Info: I have a Material Trucking Database that contains detail
information about material being hauled each day. My Main Table is called
Material _Trucking_TB. This table has many different fields, a few being
Trucking Company, Truck Number, Qty, Loads.

I have support tables which include Truck_Co_TB, which list all the
different
truck companies; Truck_Detail_TB, which list the Truck_Co (PK), Truck_Nbr
(PK),
Truck_Type; Truck_Type_TB which has the qty for each different truck type.
Ex.
Company A - Has 15 different Trucks - 4 different truck types

On a Form - through a Lookup Value the End User Selects Company A. On the
Truck_Nbr field how do we only show Company A's Truck_Nbrs?

We need to enter Qty of material hauled that day. Sometime we
have tickets giving the total qty & sometimes we don't. When we have
tickets,
I'll have the End User enter the Qty value. If we don't have tickets I
need to pre-
fill the Qty value from the Truck_Type support Table and then have the End
User
enter the Number of Loads.

I have a Y/N check box field called Tickets. If the value is No - How do
I pre-fill
the Materail_Qty field with the Truck_Type_TB.TT_Qty Field value? If the
value
is Yes I want the end user to enter this value.

 

[Mr. B]

I know what I want to do, but I don't know how to do it in Access!

Background Info: I have a Material Trucking Database that contains detail
information about material being hauled each day. My Main Table is called
Material _Trucking_TB. This table has many different fields, a few being
Trucking Company, Truck Number, Qty, Loads.

I have support tables which include Truck_Co_TB, which list all the
different
truck companies; Truck_Detail_TB, which list the Truck_Co (PK), Truck_Nbr
(PK),
Truck_Type; Truck_Type_TB which has the qty for each different truck type.
Ex.
Company A - Has 15 different Trucks - 4 different truck types

On a Form - through a Lookup Value the End User Selects Company A. On the
Truck_Nbr field how do we only show Company A's Truck_Nbrs?

We need to enter Qty of material hauled that day. Sometime we
have tickets giving the total qty & sometimes we don't. When we have
tickets,
I'll have the End User enter the Qty value. If we don't have tickets I
need to pre-
fill the Qty value from the Truck_Type support Table and then have the End
User
enter the Number of Loads.

I have a Y/N check box field called Tickets. If the value is No - How do
I pre-fill
the Materail_Qty field with the Truck_Type_TB.TT_Qty Field value? If the
value
is Yes I want the end user to enter this value.

Kely,

You mention Lookup values, I would think that you would be using combo
boxes for having your users to select the trucking company. Then you
would have another combo box that would get updated after a company is
selected from the first combo box and that combo box would only show
the values available for the selected company.

As for having the user to enter a value if a check box is checked, you
can use code in the After Update event of the check box to set the
focus (move the cursor) to the field where you want the value to be
entered. Then you can again check to be sure that they did enter a
value in this field in the appropriate event of the control where you
require them to make an entry.

HTH

Mr. B