Access 2007 Form Problem

[TVComputer]

In Access 2007 I am trying to set up a form that will allow me to
input values based on selections inside a combo box. I would like to
be able to select 3 (or more) different items inside the combo box and
apply different values to each of them that will be different values
for each record.

For example, on a particular customer record I would list different
items (camera, computer, tv, etc) and when I click on them inside the
combo box it would allow me to apply a date of when those items will
be ready for this particular customer. Then, it will show only those
values (item name and date) on the form.

Hopefully this isn't too confusing. I'm not really sure this is even
possible, but I'm hoping it is. Thanks in advance for your help!

 

[John W. Vinson]

In Access 2007 I am trying to set up a form that will allow me to
input values based on selections inside a combo box. I would like to
be able to select 3 (or more) different items inside the combo box and
apply different values to each of them that will be different values
for each record.

For example, on a particular customer record I would list different
items (camera, computer, tv, etc) and when I click on them inside the
combo box it would allow me to apply a date of when those items will
be ready for this particular customer. Then, it will show only those
values (item name and date) on the form.

Hopefully this isn't too confusing. I'm not really sure this is even
possible, but I'm hoping it is. Thanks in advance for your help!

Sounds like you're starting in the middle of the project. Forms and Combo
boxes do not store data; they are merely tools to manage data stored in
Tables. You will need your table structure correct before you'll be able to
get forms to do what you want!

It SOUNDS like you have a typical manyu to many relatioinship: each customer
can buy zero, one, or many Items, and each Item may be bought by zero, one, or
many Customers. This needs THREE tables - a table of customers, a table of
items, and a table of Purchases, with links to both these tables (a CustomerID
field and an ItemID field). You'ld use a form based on Customers, with a
subform based on Purchases; on the subform you'ld have a combo box bound to
the ItemID field, with the combo based on the Items table.

See the Northwind sample database Orders form for a working example. You may
also want to check out some of these resources:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials