Form not passing data to query

[bobfin]

Help, I have a simple form. 1 Field "NCR Number" and a Button to execute the report. I Enter a valid number and it calls a report speceifc to that number.


Problem is that it pops up the query asking for the number. Enter the number again then it works.

What am I doing wrong?



Bob

[pbaldy]

Likely you've misspelled the field name either in the query or in your code (which you didn't post). It needs to match exactly.

[bobfin]

Checked that. I copied and pasted to make sure.

I know I am doing something wrong..

[pbaldy]

The parameter prompt is Access telling you "I don't know what this is". You still haven't posted your code or the SQL of the query. You have a space in the name above. Presuming that's really the field name, is it bracketed as it would need to be?

[bobfin]

Ok again I ma new to Access so here is what I have. I think this is what you were looking for??

Command to open unbound form

Private Sub Command142_Click()

DoCmd.OpenForm "1form"
End Sub


1Form "Name of Form"

1 Field called text0
1 Button with the following code

Private Sub Command2_Click()
On Error GoTo Err_Command9_Click

Dim stDocName As String

stDocName = "1"
DoCmd.OpenReport stDocName, acPreview

Exit_Command9_Click:
Exit Sub

Err_Command9_Click:
MsgBox " Oops Need Input "
Resume Exit_Command9_Click
End Sub


Query Criertia

Linked to NCRNumber
[Forms]![Non-Conformance Form]![NCRNumber]

[pbaldy]

Is this form open when the report opens?

[Non-Conformance Form]

If so, can you post the db?

[bobfin]

Here is a screen shot.
Highlighted Account Tab calls the Main Form
When I add a valid Account # and Click the Button

I would upload it but it has sensitive data.
I do not know how to clear data without deleterious the tables.

Enter Parameter Value ends up.

Nothing else is open

Bob

[bobfin]

Sorry forgot to attach the file

[pbaldy]

I assume when you say nothing else is open that the named form isn't open. The form named in the query must be open when the query/report runs.

[bobfin]

That is correct. In my mind it should work but thats not saying much..

Bob

[pbaldy]

The query won't open the form for you. It must already be open.

[bobfin]

Ok I am confused.


The form calls the report. In the Report it is linked to the query is that what you mean?

Bob

[pbaldy]

Can you post a copy of the db without the tables in it so there's no sensitive data?

[bobfin]

I figured it out. It was my query it was point to the wrong table.

Thanks,

Bob