Need assistance with an Access 2007 Sub Form


F

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.
 
Ad

Advertisements

J

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top