Combo Box in subform help needed

[docsix]

I am having trouble populating a combo box in a subform. Currently I have two combo boxes on a single form that works. This is my current setup:

Table:Facilitie s -
FacilityID ... FacilityType
1 ............ Bus
2 ............ Library

Table: Additional
DetailID .... Details .............. FacilityID
1 ..............T Imetable .......... Bus
2 ..............S heltered ........... Bus
3 .............. Opening hours ... Library
4 ............. Borrowing ........... Library

The form is saved in a third table called "Saved"
Table: Saved
SavedID .... FacilityID .... DetailID

The saved table takes the combo box inputs. Table:Facility and Table:Additiona l are linked via FacilityID column. Basically if I click on Bus in combo box 1 it populates combo box 2 with Timetable and Sheltered, which I then choose one of them.

This is done with an after update event in combo box 1:

Option Compare Database

Private Sub Facility_AfterU pdate()
Details = Null
Details.Requery
Details = Me.Details.Item Data(0)
End Sub

Private Sub Form_Current()
Details.Requery
End Sub

Private Sub Form_Load()
If IsNull(Facility ) Then
Facility = Me.Facility.Ite mData(0)
Call Facility_AfterU pdate
End If
End Sub

Combo box 2 has the selection code:

SELECT Additional.Deta ilID, Additional.Deta ils, Additional.Faci lityID FROM Additional WHERE (((Additional.F acilityID)=Form s!Saved!Facilit y)) ORDER BY Additional.Deta ils;

What I would like to do is move combo box 2 into a subform and add another field to describe what the details mean. I don't know what coding chages I have to make or even if I need another table to store the new information.

[PEB]

Simply you need to change the references to the field Details including the path like:

MyForm!Control. Form![Detail]

[docsix]

Anyone have an idea or a downloadable example of how to fix this problem?