combo box, need help populating

  • Thread starter Thread starter Barry
  • Start date Start date
B

Barry

Hi -

This is my first week using Access. I am having
difficulties populating text box with information
selected from a combo box. I have 3 tables and 1 main
form that will be used to enter new job orders as they
come in:

tblAdditions:
AdditionID (PK)
AdditionName

tblCustomers:
CustomerID (PK)
Company Name
BillingAddress
City
State
ZipCode
Branch
PhoneNumber

tblJobType:
JobTypeID (PK)
Job Type

FormOrders:
ProjectID (PK)
ProjectNumber
CompanyName (Combo Box)
OrderDate
NeedByDate
JobType (Combo Box)
Addition (Combo Box)

I have two questions. First, the ProjectNumber field is
a text box that I would like to start at the number 100
and increase by one autmatically for every new order that
is entered. I already have one record entered in this
form which is only for testing purposes.

Second, after selecting a company name from the
CompanyName combo box, I am wanting other information
from the Customers table to automatically populate the
fields such as address, city, state, zip. Selecting a
company from the combo box is working fine but after
selecting it, the other fields are populated with the
company name that was selected in the combo box, not the
information. I have the control source for these fields
set to the CompanyName combo box, which is probably why
they show the same information that is selected from the
combo box. I think I am needing to enter a code
somewhere to tell it where and what column I am needing
but I have no idea on how to do this or where to enter
the codes.

Any help/tips/or suggestions woul be appreciated.
Thank you in advance.
 
Hi Shawna

I am wanting to enter the information you provided me for
setting the Project Number to a certain number, but where
do I enter it at?.
 
Back
Top