Linking 8 combo box together

[Sinned via AccessMonster.com]

i am trying to put a Driver Check in together for when truck check the
information is being pulled from our system database. right now when trucks
check in we have a exel sheet and enter all the data in
Bill #
Customer#
Customer
Ship to #
Ship to customer
Total Weight
Total # or product
City and stat is it going to.

this infomation is all saved into our system. i have a query pulling the
information into 8 combo boxes with 8 different queries i have 1 query set up
that pulls all this information. can i have it where once the select the
Bill number all the coresponding combo boxes are automaticly selected? we
have other information that is not in our sytem that needs to be updated like
truckers name truckline etc...

all this information needs to be saved to my table. where i can pull up
reports. is this possible?

table - tbl_Driver Check-in

fields
ID
C#
STN
CN
STC
C&S
TL
P/U
L#
Name
BOL#
Dock
Time
Date
TW
TB
Tru
Tra
PB
Misc

queries - qry_driver_check-in <-- all the information
fields
BLH_BL_NO <-- BILL #
BLH_CUS_NO <-- CUSTOMER #
BLH_SLD_NM <-- CUSTOMER NAME
BLH_SHP_NM <-- SHIP TO NAME
BLH_SHP_CITY <-- CITY AND STATE
BLH_TOT_WGT <-- TOTAL WEIGHT
PRD_PCS_PER_BDL <-- QUANITY
BLH_SHP_NO <-- SHIP TO NUMBER
BLH_BL_BRH <-- MY DIVISON (NEEDED TO ONLY SHOW OUR DIVISION)
BLH_SHP_CD <-- LOAD STATUS (NEEDED TO ONLY SHOW NON LOADED BILLS)

or
qry_BOL#
qry_bundles
qry_city and state
qry_customer name
qry_customer#
qry_ship_to_#
qry_ship_to_name
qry_weight