How to Implement Inner join ??

[SAM453]

Hi guys,

I am building a front end on access with sql as a back end. I am using linked tables to view the data.

strCriteria1 = "Station=" & Me.Combo8.Value & ""
strCriteria2 = "[BusinessDate] Between #" & Me.Text0 & "# and #" & Me.Text3 & "#"
strCriteria5 = strCriteria2 & " And " & strCriteria1

If IsNull(Text0) = False And IsNull(Text3) = False And IsNull(Combo8.Value) = False Then
DoCmd.OpenTable "AS_DATA", acViewNormal
DoCmd.ApplyFilter , strCriteria5
End If

It works gud since i have both columns in my AS_Data table.

What i want is i Have another table STORE. I want to join to this table. How can i join that table to the above docmd.opentable and docmd.apply filter logic ???

How to use inner join with docmd.opentable and apply filter?? is this possible ??
What's my alternate methods??

Plz help me out.

Thanks,
SAM.

 

[SkipVought]

hi,

Believe that you'd have to do the join in a query. Then execute that query as you would a table in your code.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SAM453]

Thanks for your reply Nuance,

I also implemented that.. now i'm having another problem..

After i execute the query it opens the table and shows the records with my conditions in my query. it's working fine.

problem is .. when i choose a column and hit the filter button then i don't see the values in filter drop down .. i only see text filer or Number filter and nothing beyond it. (I mean to say we will get a list of distinct number of that column and we can uncheck them and select one value it will filter the records right i don't see that. )

How to fix this??
And their is not way to implement inner join besides query method???

Sam.