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'