Dlookup over 2tables AND referring to a combobox

[FL0XN0X]

Dear,

As shown in the screenshot above, I have got 2 tables, i.e. "Jaartabel" and [Extra Opvang] which are related.

Now, what I want to achieve is, depending on the year selected by a combobox (cboYear in form "Mainform"), the correct record is selected from the [Extra Opvang] table. The year however is in table "Jaartabel"

Thus, I'm looking for something like : DLookUp("[Maandprijs ExtraOpvang]";"Extra Opvang";"[ExtraOpvangType]='X VM'" AND WHERE [Jaartabel].[Jaartal]= Value of cboYear

First part of the Dlookup function is working , but I'm looking for the code of the 'bold part'

[isladogs]

This should be correct:

DLookUp("[Maandprijs ExtraOpvang]","Extra Opvang","[ExtraOpvangType]='X VM' And [Jaartabel].[Jaartal]=" & cboYear)

NOTE: The DLookup separators are normally commas as shown
You used semicolons - if that is correct for your regional settings, swop them back

[FL0XN0X]

Hi ridders52,

The Expression builder returns no error, however, the result is #Name?

[FL0XN0X]

The first part is working: DLookUp("[Maandprijs ExtraOpvang]";"Extra Opvang";"[ExtraOpvangType]='X VM'

for the AND part, I'd like to add the JaartalId, which is a foreign key to [Jaartabel].

The JaartalId, can be retrieved by : =DLookUp("[Id]";"Jaartabel";"[Jaartal]= " & [Forms]![Overzicht facturatie]![cboJaar])

Thus now I need to combine both expressions but I do not succeed ... (yet)

[FL0XN0X]

OK, got it working:

=DLookUp("[Maandprijs ExtraOpvang]";"Extra Opvang";"[ExtraOpvangType]='X VM' AND [JaartalId]=" & DLookUp("[Id]";"Jaartabel";"[Jaartal]= " & [Forms]![Overzicht facturatie]![cboJaar]))

[isladogs]

Well done. Sorry - hadn't seen your earlier replies
It wouldn't have been possible to get the correct code from your initial description alone