Get a specific value from a table as soon as you open the form

[Akchayan]

So i have a table that looks like this:

As you can see there is a row with the name "Jahr" and with the name "Monat".
Monat = Month
Jahr = Year



And I would like that as soon as my form is opened, the output of "Target hourly balance month" is made in a text field.
That means e.g:
It is today 7 June 2023
Then I want the output of the year 2023 in June:
So the text field must say 198.


How do I do that?

[Gicu]

You use a dLookup with today's month and year as the criteria:

DLookup("Target hourly balance month","YourTable","Jahr=" & Year(Date()) & " AND Monat = " & Month(Date()))

Cheers,

[Akchayan]

Thank you very much!