Hey all.

I am currently attempting to setup a little database for college..sounds fun right...hahahahaha.

I have to setup a search funciton and havent got the foggiest IDea hot it would be done.

So far ive got a button that checks to see if a list box has a value selected, in this case at the moments its if TblcustomerDetails is selected.

At the moments it set ti make the Table open using the DoCmd.OpenTable command and works fine but I cant figured out how to get it to then look at the text box's (search criteria) to see if there is any information and then open the table with the filtered results.

Anyone got any ideas?

Help would be awesomely appreciated

To look a text box the VBA is textBox.value

but access has lots of nice wizards.

1st create both forms

the forum with the list box/ text box.
and a dataview form (to show all results)

then add a button on the listbox forum, you'll get a promt asking what kind of buton you need.

go to "form operations"/ "open a form".

click "next"

select the form to open..

click "next"

select "open form with specific data on displey"

click "next"

you should now have a list of items from form one and two, select the text/list box.

from the list on the left and the corasponding item (what you are looking for) in the right one. then click the <-> button.

Click "next"

finish he rest of the wizard and it should now work..

Hope this helps.

lol i hated databases at college, my tutor was a dick and the rest of the class was crap, i mean i broke my arm and i was still ahead of everyone else when i finally went back to the lesson 2months later!

I h8ed them too, until i started working with em, now they are ok, i juts dont do access vba.

Access was my least favourite course at school. Visual basic etc were a lot cooler

I was the same - lol - until i realised tht they were the same thing access uses VBA is just a watered down version of VB, abit diffrent in places but if you know VB access is a dodle

Ahh for the seach thing I hafta code it myself...

But I havent really used access or VBA so its all foreign to me.

Yeah but I only learned VB after Access

meh i never did vb i was only on the Alevel course [spread over two years]