Hi all.. I'm stuck! I'm doing a search and I can't seem to get all the fields in my form to populate.. I have a combo box where an individual can select who they want to search on. Right now it's only pulling data from one table and I need to structure the query but since I am stealing code from random places I'm not sure how to do this..
If Len(Me!cboSelect & "") > 0 Then
' Construct SQL
Select Case optChoose
mstrSQL = "SELECT * FROM tblCorrespondence WHERE " _
& "ClientID In (SELECT DISTINCTROW " _
& "ClientID FROM tblClient WHERE ClientName Like '*" _
& DoubleQuote(Me![cboSelect]) & "*')"
So as it is right now.. only one tab in the form has data.. the tblClient page doens't have anything populated as I am only asking to select from tblCorrespondence
This is my query that actually fills out all the fields in both tabs of the form...
How do I incorporate this into the above query??