G
Guest
Hi. I am trying to create a report like many others that I have successfully
made in the past but can't figure out what I'm doing wrong here.
I have a query that asks for a user-selected input parameter:
WHERE (((tblAuctions.AuctionName)=[Forms]![AuctionParam]![FindAuction]))
My report calls for the same thing:
Private Sub Report_Close()
DoCmd.Close acForm, "AuctionParam"
End Sub
Private Sub Report_Open(Cancel As Integer)
DoCmd.OpenForm "AuctionParam", , , , , acDialog
If Not IsLoaded("AuctionParam") Then
Cancel = True
End If
End Sub
The query returns the correct information. However, the report can't seem
to figure out what Auction was selected and returns nothing. I have
AuctionName in the Page Header and it is blank.
Do I have a mismatch somewhere? Thanks for the help!
made in the past but can't figure out what I'm doing wrong here.
I have a query that asks for a user-selected input parameter:
WHERE (((tblAuctions.AuctionName)=[Forms]![AuctionParam]![FindAuction]))
My report calls for the same thing:
Private Sub Report_Close()
DoCmd.Close acForm, "AuctionParam"
End Sub
Private Sub Report_Open(Cancel As Integer)
DoCmd.OpenForm "AuctionParam", , , , , acDialog
If Not IsLoaded("AuctionParam") Then
Cancel = True
End If
End Sub
The query returns the correct information. However, the report can't seem
to figure out what Auction was selected and returns nothing. I have
AuctionName in the Page Header and it is blank.
Do I have a mismatch somewhere? Thanks for the help!