Recent content by kwazie_boy

thanks for that but i was after a tutorial to explain how to make my combo box appear in the query popup when asked which month you want to find... lets say i create a from called querysource and put my combo box in there which contains all the months listed. How would i make that combo box...

i have tried messing with that but am having trouble. any chance of a mini tutorial step by step? cheers, Will

I want a query where instead of being asked 'what month would you like' and the user has to type the month manually, I would like a drop down list to appear in the box and the user being able to select from that...how would i do this. Thanks a lot, Will

never mind, found it. thanks

and how would i do that?? thanks

still nothing...thanks for ur help but i think ill find another way around it...maybe a new record button when the form is already open. thanks, will

Private Sub Command9_Click()

btw, the module is called 'module1' if that makes any diff

i have [code] Private Sub Command9_Click() OpenAndNew End Sub [code] and i get an error 'runtime 424, object required

actually, i have now created a new button and pasted that OpenAndNew thing in there and when I click the button nothing happens

actually, i have now created a new button and pasted that OpenAndNew thing in there and when I click the button nothing happens

actually, i have now created a new button and pasted that OpenAndNew thing in there and when I click the button nothing happens

actually, i have now created a new button and pasted that OpenAndNew thing in there and when I click the button nothing happens

actually, i have now created a new button and pasted that OpenAndNew thing in there and when I click the button nothing happens

where in the code do I add OpenAndNew???When i build event on the existing button it is already full of code...