"Query input must contain at least one table or query"

[FL0XN0X]

Hi,

I need following Insert Query:

INSERT INTO [Contracttype] ( ContractType, [Maandprijs ContractType], JaartalId )
VALUES (Forms![Aanpassing prijzen].[Subform_Bijkomende_ContractType].Form![ContractType], Forms![Aanpassing prijzen].[Subform_Bijkomende_ContractType].Form![Maandprijs], (Select Id from Jaartabel WHERE Jaartal= Forms![Aanpassing prijzen].[Subform_Bijkomende_ContractType].Form![Jaartal]));

But it results in the message : "Query input must contain at least one table or query"

Does anypne know what is the issue?
Thanks in advance,
Kind regards,
Bart

[CJ_London]

not sure but think you are missing a form in each of your values

Forms![Aanpassing prijzen].form.[Subform_Bijkomende_ContractType].Form![ContractType],

[FL0XN0X]

hi,

No, that is not it....

When I test the Select statement with hardcoded values (not retrieved from the form), it return correctly the Id, but as soon as I put this Select statement as part of the Insert Query, it seems not to work .... :-s

[John_G]

Is [Contracttype] actually the name of a table? My guess is that it is not, especially since Contracttype also is the name of a field within it.

[CJ_London]

No, that is not it....

When I test the Select statement with hardcoded values (not retrieved from the form), it return correctly the Id, but as soon as I put this Select statement as part of the Insert Query, it seems not to work .... :-s

my point was the 'path' to the control looks to be incorrect. And I don't see a select statement