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

 

[raskew]

Sweetie -

...adapted from the one attached.

there ain't nothing attached nowhere and it doesn't get any better when you post it three times. Monitors, could you do your jobs and help eliminate the retards?

Best wishes - Bob

 

[michellerobinso]

apologise, it kept crashing.


please now see attached

 

[RV]

See sample.
I suggest you read up a bit more on Access, events and VBA

RV