Object required error?

[kalebson]

I am using a combo box w/ this query:

SELECT DISTINCT [ReceivedData].[Date] FROM ReceivedData;

I amd using this box to seect a date for a report run using this:

Private Sub Command14_Click()
On Error GoTo Err_Command14_Click

Dim stDocName As String

stDocName = "AbanRateForForm

DoCmd.OpenReport stDocName, acPreview, , "ReceivedData.[Date] = #" & Froms!AbanRateForForm!SelectDate & "#"

Exit_Command14_Click:
Exit Sub

Err_Command14_Click:
MsgBox Err.Description
Resume Exit_Command14_Click

End Sub

However when I click the button I get "object required" error...could someone tell what im missing here..TIA.

 

[PHV]

Replace this:
Froms
with this:
Forms

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kalebson]

OMG im an idiot.....fresh eyes always the answer..