filter by form field

[Guest]

I can't quite get this right:

I have a form: "Cashiering"

It has a combo called "findbybidnumber" that finds a particular record and
displays it on the form, based on the field "bidnumber"

I made a button called "print_invoice" to open a report "Item Invoice" which
I would like filtered by "bidnumber" on my form, which is the same number
also displayed in "findbybidnumber"

Problem is, the field on my report is also called "bidnumber" and I can't
get the syntax right.

Private Sub print_invoice_Click()
Dim strWhere As String

strWhere = "[bidnumber] = " & [bidnumber]
DoCmd.OpenReport "Item Invoice", acViewPreview, , strWhere
End Sub

 

[Duane Hookom]

What's the error or issue? What doesn't work? What is the data type of
BidNumber?

 

[Guest]

"bidnumber" is a numeric field.

"Run-time error '3079':
The specified field 'bidnumber' could refer to more than one table listed in
the FROM clause of your SQL statement."

I take it to mean that the names of the field are both the same, starting
point and desination.

What's the error or issue? What doesn't work? What is the data type of
BidNumber?

--
Duane Hookom
MS Access MVP

I can't quite get this right:

I have a form: "Cashiering"

It has a combo called "findbybidnumber" that finds a particular record and
displays it on the form, based on the field "bidnumber"

I made a button called "print_invoice" to open a report "Item Invoice"
which
I would like filtered by "bidnumber" on my form, which is the same number
also displayed in "findbybidnumber"

Problem is, the field on my report is also called "bidnumber" and I can't
get the syntax right.

Private Sub print_invoice_Click()
Dim strWhere As String

strWhere = "[bidnumber] = " & [bidnumber]
DoCmd.OpenReport "Item Invoice", acViewPreview, , strWhere
End Sub

 

[Duane Hookom]

Your report has two or more tables each with bidnumber appearing in the SQL
statement. Don't include duplicate field names in queries.

--
Duane Hookom
MS Access MVP

"bidnumber" is a numeric field.

"Run-time error '3079':
The specified field 'bidnumber' could refer to more than one table listed
in
the FROM clause of your SQL statement."

I take it to mean that the names of the field are both the same, starting
point and desination.

What's the error or issue? What doesn't work? What is the data type of
BidNumber?

--
Duane Hookom
MS Access MVP

I can't quite get this right:

I have a form: "Cashiering"

It has a combo called "findbybidnumber" that finds a particular record
and
displays it on the form, based on the field "bidnumber"

I made a button called "print_invoice" to open a report "Item Invoice"
which
I would like filtered by "bidnumber" on my form, which is the same
number
also displayed in "findbybidnumber"

Problem is, the field on my report is also called "bidnumber" and I
can't
get the syntax right.

Private Sub print_invoice_Click()
Dim strWhere As String

strWhere = "[bidnumber] = " & [bidnumber]
DoCmd.OpenReport "Item Invoice", acViewPreview, , strWhere
End Sub

 

[Guest]

Thank you, I added the table name to all of the field names, and now
everything is good.

Your report has two or more tables each with bidnumber appearing in the SQL
statement. Don't include duplicate field names in queries.

--
Duane Hookom
MS Access MVP

"bidnumber" is a numeric field.

"Run-time error '3079':
The specified field 'bidnumber' could refer to more than one table listed
in
the FROM clause of your SQL statement."

I take it to mean that the names of the field are both the same, starting
point and desination.

What's the error or issue? What doesn't work? What is the data type of
BidNumber?

--
Duane Hookom
MS Access MVP

I can't quite get this right:

I have a form: "Cashiering"

It has a combo called "findbybidnumber" that finds a particular record
and
displays it on the form, based on the field "bidnumber"

I made a button called "print_invoice" to open a report "Item Invoice"
which
I would like filtered by "bidnumber" on my form, which is the same
number
also displayed in "findbybidnumber"

Problem is, the field on my report is also called "bidnumber" and I
can't
get the syntax right.

Private Sub print_invoice_Click()
Dim strWhere As String

strWhere = "[bidnumber] = " & [bidnumber]
DoCmd.OpenReport "Item Invoice", acViewPreview, , strWhere
End Sub

 

[Guest]

I think you missed my point of never including duplicate field names. You can
alias filed/columns but this should only be used if the columns don't contain
the same value as another column in the query.
--
Duane Hookom
Microsoft Access MVP

Thank you, I added the table name to all of the field names, and now
everything is good.

Your report has two or more tables each with bidnumber appearing in the SQL
statement. Don't include duplicate field names in queries.

--
Duane Hookom
MS Access MVP

"bidnumber" is a numeric field.

"Run-time error '3079':
The specified field 'bidnumber' could refer to more than one table listed
in
the FROM clause of your SQL statement."

I take it to mean that the names of the field are both the same, starting
point and desination.

:

What's the error or issue? What doesn't work? What is the data type of
BidNumber?

--
Duane Hookom
MS Access MVP

I can't quite get this right:

I have a form: "Cashiering"

It has a combo called "findbybidnumber" that finds a particular record
and
displays it on the form, based on the field "bidnumber"

I made a button called "print_invoice" to open a report "Item Invoice"
which
I would like filtered by "bidnumber" on my form, which is the same
number
also displayed in "findbybidnumber"

Problem is, the field on my report is also called "bidnumber" and I
can't
get the syntax right.

Private Sub print_invoice_Click()
Dim strWhere As String

strWhere = "[bidnumber] = " & [bidnumber]
DoCmd.OpenReport "Item Invoice", acViewPreview, , strWhere
End Sub