Making a search form

[Guest]

I need help writting code behind a search form i made.
It has combo boxes of different things you can search by account number,
Date etc what is the code behind the button that will make another form pop
up with the info i asked to search by in it?

 

[Marshall Barton]

I need help writting code behind a search form i made.
It has combo boxes of different things you can search by account number,
Date etc what is the code behind the button that will make another form pop
up with the info i asked to search by in it?

Here's a article on that topic:
http://allenbrowne.com/ser-62.html

 

[Dorothy]

Here's a article on that topic:http://allenbrowne.com/ser-62.html

Have you tried the following?

private sub currentform_click()
docmd.openform "form2", , ,
end sub

where form2 is the form you want to open when the button is clicked.

Good luck!

Dorothy
(e-mail address removed)