nochannels = DLookup("[FTAChannels]", "FTATypes", "[FTAType] = " &
Forms!FTANumbers!FTAType)

Why doesn't this work?

FTAChannels = Field name
FTATypes = Table name
FTAType = FieldName

It gives the error message:

The expression you entered as a query parameter produced this error. The
object doesn't contain the Automation object 'FTA.''

What does that mean?

All I'm trying to do is let 'nochannels' equal 'FTAChannels' from the
'FTATypes' table.

Please help, anybody.

Regards,
Nick Rowlands

What is the value of Forms!FTANumber!FTAType? If it is a number, then this
is probably not the problem and you can ignore me, but if it is text you
might try the following:
nochannels = DLookup("[FTAChannels]", "FTATypes", "[FTAType] = ' " &
Forms!FTANumbers!FTAType & " ' ")

(Note:extra spaces added around the single quotes for readability). Even if
the control or property value of Forms!FTANumbers!FTAType is text, you will
need to enclose that text in single quotes to use it as criteria.

Hope this helps.

Peter