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?
Thank you. I wont be much help now but got everything on order to learn and it looks like I am going to be playing with this software for a long time now.
Hopefully in the future I will be able to contribute. Just have to get my own personal little nightmare figured out right now.
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...
Well after many attempts to stand under my desk and jump up quickly here I am.
I offered to make a small database at work to monitor parts. My boss quickly seen more options and I managed to cover those as well. Now he has seen more and it has spiraled completely out of control. I will be...