How to filter the record source of a subreport correctly? (1 Viewer)

[FISHiEE]

Hi,

I have the following as the filter condition for the record source on a subreport:

[Door_Part_Number] = DLookup("[Door Part Number1]", "3-ENQUIRY DATABASE", "[Enquiry Number] = 10056")

This works perfectly fine, however I would like to replace 10056 with the contents of a textbox "Text327" - don't ask. I didn't design it!

I haver tried the following:

[Door_Part_Number] = DLookup("[Door Part Number1]", "3-ENQUIRY DATABASE", "[Enquiry Number] = [Text327]")

But just get the error message "The object doesn't contain the automation object 'Text327'".

Any ideas what the correct syntax is for this?

THanks in advance

John

 

[FISHiEE]

Have managed to get around this anothwer way now.