vb arghhh i dont understand it!

[michellerobinso]

i have a search on my database adapted from the one attached.

i would like it to display the

month field
return number (ID)
year field

the month and the year are formated =Format(Month(Date()),"0")

but when i run the query and the search they are just blank, is that because it will only display in the form?

how can i get it to display this information?

many thanks

Michelle