Combo Box Confusion!!

[Ren]

I am trying to create a dtb for tracking all incoming calls at my office.
Its working at the moment but I would like to simplify it by a few things:

a. Basing combo boxes on another’s selection i.e.:

Drop down list 1- row source type is table/query<single column table>
–Calling (has a list of peoples names that frequently call in)

Drop down list 2- row source type is table/query <single column table>-
Company (list of co’s from the people in the above list)

I want drop down list 2 to automatically bring up the company that persons
name in drop down 1 is affiliated with.


b. Automatically putting in the name/co of someone new to the drop down
list 1 & 2. As of now, anyone new calling in, I have to go back manually and
type in their name and then their co into their tables. Its not that big of
deal but just takes a lot of time that I could spend doing something else.


c. Some of the people calling in are from management’s companies that
oversee different properties. Is it possible to add a drop down #3 list that
will list any properties that the company in drop down 2 own?

d. Automatically add the date and time for each call on a new record.

I’ve been trying to figure these things for a while now and I just can’t
wrap my brain around it when the code stuff comes into it. If someone could
please explain this (SIMPLY!) I would appreciate it TONS!

Just a bit more info if it helps:

All the tables:

Calling (single column source)
Company (single column source)
For (single column source)
Log:
Fields:
Date
Time
For
Calling
Company
Number
Nature of Call
Delivered
Follow up
Auto #

o yea, Access 2003
Thank You So V. Much!

 

[Amy Blankenship]

I am trying to create a dtb for tracking all incoming calls at my office.
Its working at the moment but I would like to simplify it by a few things:

a. Basing combo boxes on another's selection i.e.:

Drop down list 1- row source type is table/query<single column table>
-Calling (has a list of peoples names that frequently call in)

Drop down list 2- row source type is table/query <single column table>-
Company (list of co's from the people in the above list)

I want drop down list 2 to automatically bring up the company that persons
name in drop down 1 is affiliated with.

You'd need to set up some sort of relationship between the Calling and
Company tables, probably you'd put CompanyID in the Calling table. Then
you'd set up the query in Combobox 2 to show the Company where [Company ID]
= Forms![Your form].[CompanyID]. In the OnChage event for Combobox 1,
requery Combobox 2. Though of course now it's just one company, you
probably don't need to use a combobox or even make it editable on the form.
You could probably create an event in the OnChange event of Combobox 1 to
just look up the company for CallingID and set that in a text label control
for display purposes only.

b. Automatically putting in the name/co of someone new to the drop down
list 1 & 2. As of now, anyone new calling in, I have to go back manually
and
type in their name and then their co into their tables. Its not that big
of
deal but just takes a lot of time that I could spend doing something else.

Set up the combobox to "limit to list" and then use a "not in list" event to
pop up a form that allows you to fill in that info.

c. Some of the people calling in are from management's companies that
oversee different properties. Is it possible to add a drop down #3 list
that
will list any properties that the company in drop down 2 own?

Not with your current table structure.

d. Automatically add the date and time for each call on a new record.

Make Now() the default value for the Date field, which incidentally should
not be called Date. That is a reserved word.

HTH;

Amy