Help with SubForms & Tables

[Acelink]

Help with SubForms & List Box

Hi... I am new to Access and just learning about databases. I created a scenario for myself and am trying to create a database. But I hit a snag

Right now I'm trying to create an overview form where I can glance at the basics and get just the bare information. I am having trouble when it comes to the subforms and subsubforms.

Problem #1:
I am not able to make sub-sub forms because the subform view is datasheet. I know I can change it to the actual Form View and create a Listbox but I don't know how to create a table that works like the datasheet. I tried making a listbox based upon the fields in my datahseet view but that just messes everything up... (I don't know how to create the listbox relations either)

I did think of a ghetto fix for this problem but the subform will still be in Datasheet View. If at all possible I would like to use Form View+Table instead for all of my subforms/subsubforms.

Problem #2:
After the subsubFrm_Patient_Vent listbox is made, I want to make it a horizontal listbox that scrolls Right to Left rather than Up and Down.

I did search the forums a little bit before posting... I believe this thread is similar to what I am looking in my first problem for but I didn't want to hijack the thread.

View attachment DB01.zip

 

[dkinley]

Not sure of your version or what exactly is it is you are trying to accomplish, so sending you here:

http://www.functionx.com/

If you look down the left-hand side there is some information for MS Access 2003 and 2007. I would suggest starting with 2003 and looking at the subforms for what I think it is you are trying to do (they don't repeat the primer in the '07 section).

-dk