I'm using Ms Access, and I'm building application where I will need to search through my records. The problem is that I created a form that contains one major table A and two subforms of table B and C.
HOw can I search through all 3 tables and be able to pull out data from all 3 and update on the fly? Is their a way to use the database engine in Visual Basic?
I can't use the FilterbyForm becuase I want to be able to search through my subforms also. Does all this make sense to any?