Using Cascading combo boxes to Enter records

[oohmygod831]

i am writing a database (Access XP) that will allow users to book in or out a particular tool from the stores.

Rather than have the user look through a combo box with an enormous list of tools i am using 3 cascading combo boxes to filter the results (Internal/External, ToolType and ToolName)

My cascading combo boxes work great but the problem i have is that i need the selection in the last combo box to be written to the toolbooked table and i cant get it to work.

The Cascading combo boxes only work when they are on a form that isn't bound to any tables. If i create a form using the wizzard and select tables to be used in the form then when i try to create the cascading combo boxes on that form i get an error saying - Data cannot be retrieved from the source you have selected. You must select a different table or query to continue in the wizzard.

I tried using a subform with the fields from the ToolBooking table in and linking the fields to the combo boxes in the main form using After Update but that didnt seem to work.

Any ideas please. Ive attached the database if thats any help.