Newbie Question: User Entered Field as Query Parameter

[AJ0424]

Hi,
I am *really* new at this - I am trying to use built in functionality because I don't have any code experience so I hope this is clear.

What I am trying to do is create a form that lets a User enter a product number and have the description returned.

The problem - I can do this through a query using the criteria (["Enter Product Number"] but that generates a popup. What I am having a hard time doing is using a form to do the same thing but to display the info where I want it to display without the popup.

What I want:
Two boxes in the form
- Box 1 lets them enter a product number
- Box 2 displays the description

Simple example of what I have:

I have:
Table with 2 fields


Product Number: Text field (char and numbers), primary key
Description: Text field

Query:
Returns two fields from table with a criteria setting requiring that the Product number: ["Enter Product Number"]


I hope I am just missing something simple because this doesn't seem like it should be complicated. If anyone can point me in the right direction, I would appreciate it.

Thanks,
AJ

EDITED to Add:
I found the solution by using the expression builder in the query design. For other newbies, the tutorial I used was:
http://fisher.osu.edu/~muhanna_1/837/MSAccess/tutorials/mainTOC.pdf

[RuralGuy]

I love it when posters are able to solve their own issues. Thanks for sharing.

[tracamonali]

Hi,
I am *really* new at this - I am trying to use built in functionality because I don't have any code experience so I hope this is clear.

What I am trying to do is create a form that lets a User enter a product number and have the description returned.

The problem - I can do this through a query using the criteria (["Enter Product Number"] but that generates a popup. What I am having a hard time doing is using a form to do the same thing but to display the info where I want it to display without the popup.

What I want:
Two boxes in the form
- Box 1 lets them enter a product number
- Box 2 displays the description

Simple example of what I have:

I have:
Table with 2 fields
Product Number: Text field (char and numbers), primary key
Description: Text field

Query:
Returns two fields from table with a criteria setting requiring that the Product number: ["Enter Product Number"]


I hope I am just missing something simple because this doesn't seem like it should be complicated. If anyone can point me in the right direction, I would appreciate it.

Thanks,
AJ

EDITED to Add:
I found the solution by using the expression builder in the query design. For other newbies, the tutorial I used was:
http://fisher.osu.edu/~muhanna_1/837/MSAccess/tutorials/mainTOC.pdf

AJ, I have to do the same thing as you had to do. However, the tutorial only opens the Index. Its doesn't open the tutorial document. Here is what I need to do:
I wish to open an Access report which should read a value from the vb form. The access report should pick up the Hospital# from a textbox and only one record should be opened. Here is my code:

Private Sub cmdCallLog_Click()
Dim strWhere As String
strWhere = "'" & txtHospID.Text & "'"

Set mAcc = New Access.Application
mAcc.OpenCurrentDatabase "............mdb"
mAcc.DoCmd.OpenReport "CTX_HDCALLS_rpt", acViewPreview, , strWhere
mAcc.Visible = True
End Sub

My problem is a popup window opens and request for Hospital# when I set up the criteria in the access report. ["Enter hospital Number"]. I do not wish this to happen. The report should be able to read Hospital# from the variable strwhere. Where am I going wrong? Any help appreciated.

[RuralGuy]

The WhereClause argument of the OpenReport command applies a filter to the RecordSource of the report. It needs to be a complete Where clause without the word WHERE.
If it is a numeric value then:
strWhere = "[YourFieldName] = " & Me.txtHospID
If it is a string value then:
strWhere = "[YourFieldName] = '" & Me.txtHospID & "'"
...replacing YourFieldName with the real name of course.

[tracamonali]

The WhereClause argument of the OpenReport command applies a filter to the RecordSource of the report. It needs to be a complete Where clause without the word WHERE.
If it is a numeric value then:
strWhere = "[YourFieldName] = " & Me.txtHospID
If it is a string value then:
strWhere = "[YourFieldName] = '" & Me.txtHospID & "'"
...replacing YourFieldName with the real name of course.

RuralGuy you are my hero. Thanks it worked.

[RuralGuy]

Just glad we could help. Have fun.