Re: [MS_AccessPros] Querying From a Form Parameter

 

Greg,

Please make sure the significant parts of the thread are included in your replies.

I didn't expect the filter to be applied. I only wanted you to be able to see the value. This was only a single step in troubleshooting.

Now you mention filtering "Product Descriptions".  Are there any "lookup" fields in this query/table? 

You can find the parameters/data type in the query properties window.

Regards,

Duane

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of xenon.blue@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, March 26, 2018 1:19 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Querying From a Form Parameter

 

Hi Duane,

Yes that does create a column in the query with the correct value listed beside every Product_No. However I was hoping to simply filter the Product Descriptions based on the Product_No to one value that could be read back to the open form.

Greg

__._,_.___

---

Posted by: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (6)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___