Command Button For Searching

[Hoagie08]

Hello all,

I just started dabbing into Access and I have created my first! I have done all the tables, queries and I have a form ( based on the tables ), but now on the form, I want to add a command button when pressed, pops open the search box based on say, Order number, and if not in database, then the option to create a new record.

Can this be done?

I have a lot of experience with Excel, but like I said, just starting Access

Thanks a bunch,

Hoagie

 

[Tim L]

Welcome to the Forum!

Yes it is possible.

Do a search in both the VBA and Forms forums for search boxes, try keywords like 'search' & 'search box' (and other variations that you can think of). You should find something that will be of use. You may have a to read many posts before you find exactly what you need, and it may be the case that you have to combine ideas from two or more threads.

As a starter, you may want to take a look at this recent thread: http://www.access-programmers.co.uk/forums/showthread.php?t=133423

HTH

Tim

 

[Hoagie08]

Thanks Tim

Thanks Tim

 

[lead 27]

The best way is to add a text box then use a comand button (find form) linked to that text box then select find particular field in form
Now when you type in the information it should bring up that form and if not it will give you a blank form to fill in