I cant locate help

[Zainder]

Either I dont know what I am looking for or I am looking for the wrong thing. But after a week and a half I am now asking for help.

I have 3 tables
-PartsTbl
-VendTbl
-PartsComboboxTbl <---combobox queries to get listings

3 forms
-PartsFrm
-VendFrm
-PartsVend

PartsVend is the main form with PartsFrm and VendFrm as sub forms. I have the filter working so that when you have a part loaded in the partsFrm it will update to the appropriat vendor. However I want a search button and a textbox on PartsVend that I can search the PartsTbl and display a part and then it will automatically update to the appropriat vendor. And a second search button and textbox that I can use just to search Vendors. I cannot figure out how to make any of the search functions work.

My VB is almost nil. And even looking at it on pages it still confuses me.

I have about 4 weeks for my "Visual Basic for the absolute beginner" and 3 other access books to arrive.

Any help would be greatly appreciated

 

[Zainder]

Guess I have asked wrong or for which I am sorry. I am sure the code is out there even a point in the right direction would help.

 

[jdraw]

There are excellent free video tutorials at
http://www.datapigtechnologies.com/AccessMain.htm
that may help with Forms and comboboxes

DataPig has a search form tutorial here
http://www.datapigtechnologies.com/flashfiles/searchform.html

Perhaps a few minutes with this site may help.

Post if you have questions, there are many here who will help/advise.

Good luck.

 

[Zainder]

thank you very much

 

[Zainder]

Well I thank you all so much I have got the search working and learned alot along the way. However once I got the search working my filter vanished.
When I am displaying a part in the PartsTbl Form I want it to update automaticaly show the correct Vendor in the VendorTbl. Any idea's?