Need assistance with an Access 2007 Sub Form

[Fred]

I am using Access 2007. I need to create a form that is based on data
contained in the following tables:Furniture, Furniture Category, and
Furniture_and_Categories

Furniture
-----------------------------------------
Furniture ID
Furniture Name

Furniture Types
-----------------------------------------
Furniture Type ID
Furniture Type Name

Furniture_and_Types
-----------------------------------------
Furniture ID (from Furniture table)
Furniture Type ID (from Furniture Types table)


I need to create a form that displays as text only, the name of a
vehicle and below that a list of all the vehicle types that can be
associated with the current vehicle. I then need to be able to add or
remove vehicle types (from the Vehicle_and_Types table) to the current
vehicle.

What is the best way to do this? I can create a sub form using the
wizard, but cannot get it to allow for entry using a drop-down to add
new records.

Any guidance would be tremendously appreciated.

 

[James A. Fortune]

I am using Access 2007.  I need to create a form that is based on data
contained in the following tables:Furniture, Furniture Category, and
Furniture_and_Categories

Furniture
-----------------------------------------
Furniture ID
Furniture Name

Furniture Types
-----------------------------------------
Furniture Type ID
Furniture Type Name

Furniture_and_Types
-----------------------------------------
Furniture ID (from Furniture table)
Furniture Type ID  (from Furniture Types table)

I need to create a form that displays as text only, the name of a
vehicle and below that a list of all the vehicle types that can be
associated with the current vehicle.  I then need to be able to add or
remove vehicle types (from the Vehicle_and_Types table) to the current
vehicle.

What is the best way to do this?  I can create a sub form using the
wizard, but cannot get it to allow for entry using a drop-down to add
new records.

Any guidance would be tremendously appreciated.

You DRIVE your furniture ? Perhaps try:

http://groups.google.com/group/comp.databases.ms-access/msg/169a25d13dbaf582

I started using Access 2007 recently, so I'm not familiar with the
subform nuances yet. A small sample of data and the results you
expect might help me to discover the specific problem you are having
with that version.

James A. Fortune
(e-mail address removed)