Change DoCmd.OpenForm to DoCmd.OpenTable

[4Wile]

I have expression:
DoCmd.OpenForm "PhoneList", acNormal, "", "[PhoneQuery].[State]=[Forms]![Phone3a]![ByLocation3]" This Works!

PhoneList = Report
Phone3a = Form
ByLocation3 = Selected State
PhoneQuery = All members address

I would like to change report(PhoneList) to table(PhoneTable)

Please specific..I'm newbe..

 

[JAXDBase]

Try:

I have expression:
DoCmd.OpenTable "PhoneList", acNormal, "", "[PhoneQuery].[State]=[Forms]![Phone3a]![ByLocation3]" This Works!

It should work since the OpenTable switches the object from a report to opening the table by running the query.

 

[4Wile]

I tried BUT it created a error message:
"Wrong number of argument or invalid property assignment"

Maybe I asked you for the wrong question...I need a
table that contains the addresses of the selected state.
I thought just changing OpenForm to OpenTable should do
it.

I'm still a newbie ... please be specific..