Search results

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...

i want to open 'Day' and go straight to a new record from the form 'Home'

:-( nope...just a novice

I am wanting to have a button on a home menu which links to another form and automatically goes to a blank record...I have looked through macros and I cant seem to find an answer there. Any ideas? Thanks, Will