Question Query not working in subform

[RobMoo]

My form works fine (I have two combo boxes synchronised on it) on its own but when I insert it as a subform into another form a query I have on a combo box doesnt work. I get the "Enter Parameter Value" pop up box.
This is the message "Forms!AirlineQuote.Airline"

My main form is called : Quotes
The Subform is called : AirlineQuote

The problem combo box is called : Tail
The combo boxes Row Source is a query called : TailQRY

This is the SQL for TailQRY :
SELECT AircraftandDOM.Details
FROM AcHeliQuoteUnion INNER JOIN AircraftandDOM ON AcHeliQuoteUnion.ID = AircraftandDOM.ID
WHERE (((AcHeliQuoteUnion.ID)=[Forms]![AirlineQuote].[Airline]))
ORDER BY AircraftandDOM.Details;

I am relatively new to ACcess so any layman help appreciated.

Thanks

 

[vbaInet]

WHERE (((AcHeliQuoteUnion.ID)=[Forms]![AirlineQuote]![Airline])

The bit in red.

 

[RobMoo]

WHERE (((AcHeliQuoteUnion.ID)=[Forms]![AirlineQuote]![Airline])

The bit in red.

Thanks but that hasnt worked... I still get the same parameter box !

 

[vbaInet]

Your main form is probably what's throwing up the error. Can you post the db?

 

[RobMoo]

its 23MB? How can I post it?

 

[vbaInet]

Just post a copy of the relevant bits. Here's how:

http://www.access-programmers.co.uk/forums/showthread.php?t=140587

 

[RobMoo]

Ive uploaded the DB now.
To replicate my issue in the AIRLINE QUOTE sub form,you will need to select an airline from the AIRLINE Combo and then try to select from the TAIL combo

 

[vbaInet]

Ive uploaded the DB now.
To replicate my issue in the AIRLINE QUOTE sub form,you will need to select an airline from the AIRLINE Combo and then try to select from the TAIL combo

It didn't come through. When you click UPLOAD, wait for the file name to appear on the small window before closing it.

 

[RobMoo]

My zipped file is only 6.79MB and Ive tried to upload through IE and Firefox and I keep getting upload failed. And i didn't do anything else whilst the window said wait? Any ideas

 

[MStef]

I think you need to change a WHERE line in your code.
WHERE (((AcHeliQuoteUnion.ID)= [Forms]![Quotes]![AirlineQuote]![Airline]))

 

[namliam]

The manage downloads window says:

Filetype Max Filesize 
zip      785.9 KB

 

[RobMoo]

I think you need to change a WHERE line in your code.
WHERE (((AcHeliQuoteUnion.ID)= [Forms]![Quotes]![AirlineQuote]![Airline]))

That'sfixed it.. Thanks very much !!