Search results

I think I know what is was, the command button was looking for data already in the textbox but there was none. So I placed monthtext = Format(Date(),"mmmm yy") as On Load Event and it worked fine. Thanks for your help, can I use the textbox to filter the results that are displayed now in...

and now I get a run time error 13 with the buttons

Thanks you guys, still stuck on one bit though. I want the form to load with the current month and year in the text box. How do I get that to display and still use the commanf buttons to change the month as I can either get one or the others to work

but I wanna use it to select different months not just this month, next month and last month. I wanna go back for example 1 year if i click the button 12 times

Ah it now displays april 10 but when I click the button it stays as April 10 and not May 10. I have

I have syntax error when I click the button

where do i put the +1 or -1 to change the month on the code and do i put =Format(Date(),"mmmm yy") as the control source as the textbox or do I put it somewhere else

I am getting no joy, my textbox is called monthtext so what code do I place on on the ON click event

ah sorry to be a pain, I am just way out of my depth here

what about displaying the year as well

I have got =Format$(DateAdd("m",0,Now()),"mmmm yy") to display the current month and year in the textbox but I am unsure how to tie this with the command buttons to go back or forward months

Hi guys, I am very new to access and VB so I am sorry of this is a stupid question. I am creating a database for my work and I would like the text box to display the current month and year. I would like to command buttons each side one to go back a month and the next one to go to the next...