How to search record from 2 different table?

[bigmon]

I have 2 table in ms access (Table A and table B).I am doing a search function which able to search the record on this 2 different table. how to do that? how to set the source?

Here is the coding for me to search record just only from Table A but i would like to make it search on Table B as well..
Private Sub btnSearch_Click()

Me.frmsubTableA.Form.RecordSource = "SELECT * FROM TableAQuery1 " & BuildFilter

' Requery the subform
Me.frmsubTableA.Requery
End Sub

 

[pbaldy]

Hard to say, not knowing how the 2 tables are related. Either joining or unioning the 2, probably. The fact that you want to search 2 different tables hints that perhaps you shouldn't have 2 separate tables in the first place.

 

[bigmon]

this is the problem. these 2 table don't have common relation or link togather. what can i do? have to create 2 seperate form to search 2 different table?

 

[pbaldy]

What do they represent?