I have a form where i have users choose year and month and then use the values in a query, which again is used in another form as header for the form, ex.:
Report for MMM YYYY (month and year)
The way the month is chosen is from a dropdownlist (Valuelist) with 2 columns, XX and YY.
How do i get the right value for the month for the header in the second form - i have just put in the fieldname from first form, but get an error (# Error) in the field in the second form.
How do i get the value YY (second column i valuelist) to be displayed in field of second form ?