Re: [MS_AccessPros] Querying From a Form Parameter

 

Hi Greg,

I would try change the SQL of the query to:

SELECT tblProducts.Prod_No, tblProducts.DESCRIPTION, [Forms]![frmSamples1]![Prod_No] as TextboxValue
FROM tblProducts;

This should create a column with the value that you entered in your form.

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 12:28 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Querying From a Form Parameter

 

Hi Duane,

Thank you for looking at this for me.

The SQL is:

SELECT tblProducts.Prod_No, tblProducts.DESCRIPTION
FROM tblProducts
WHERE (((tblProducts.Prod_No)=[Forms]![frmSamples1]![Prod_No]));

Yes the query does return a value if I put in a hard value into the criteria field.

I do not have any parameters declared which is why I am thinking this may be the problem and I am not sure how to do this.

The control in the form is a text field (unbound).

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 (4)

---

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

.

__,_._,___