When I click the Command Button to open a form I receive the error:
Object Reuired.

This form is a subform connected to a main form.

Any suggestions?

Thanks!

Zuf

Here is the code behind the Command Button:

Private Sub Command108_Click()
On Error GoTo Err_Command108_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmQuery5"

' stLinkCriteria = "[CallDate] Between [Forms]![Main]![Child89].
[Form]![txtBeginQAEvry5th] And [Forms]![Main]![Child89].[Form]!
[txtEndQAStopEvry5th]"
stLinkCriteria = "[CallDate] Between #" & txtBeginQAEvry5th.Value
& "# and #" & txtEndQAStopEvry5th.Value & "#"

DoCmd.OPENFORM stDocName, acNormal, , stLinkCriteria, acFormEdit

Exit_Command108_Click:
Exit Sub

Err_Command108_Click:
MsgBox Err.Description
Resume Exit_Command108_Click

End Sub

zufie wrote:
STOP
'to step thru abd learn what line causes the error.
MSGBOX stLinkCriteria

On Jul 27, 11:35*am, Salad <o... (AT) vinegar (DOT) com> wrote:


Here's how my code looks after I changed it:

I get a Syntax error regarding the line: stLinkCriteria = "[CallDate]
Between "#" &

Any ideas?

Thanks,

Zufie


Private Sub Command108_Click()
On Error GoTo Err_Command108_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmQuery5"

stLinkCriteria = "[CallDate]Between "#" &
[Forms]![Main]![Child89].[Form]![txtBeginQAEvry5th] = "#" And "#"
& ""
[Forms]![Main]![Child89].[Form]![txtEndQAStopEvry5th] = "#"

Debug.Print stLinkCriteria
Stop

DoCmd.OPENFORM stDocName, acNormal, , stLinkCriteria, acFormEdit

Exit_Command108_Click:
Exit Sub

Err_Command108_Click:
MsgBox Err.Description
Resume Exit_Command108_Click

End Sub

zufie wrote:
Sometimes I might have
On Error GoTo Err_Command108_Click
and temporarily I change it to
'On Error GoTo Err_Command108_Click
effectively disabling the error action.

I think you need to now what's the value of [txtBeginQAEvry5th] and
[txtEndQAStopEvry5th]. Most likely it's a reference problem. For
example, I might enter
msgbox [Forms]![Main]![Child89].[Form]![txtBeginQAEvry5th]
or
msgbox [Forms]![Main]![Child89].[Form]![txtEndQAEvry5th]
I guess your problem is with one or both of those controls.

Here's a handy link.
http://www.mvps.org/access/forms/frm0031.htm

Is your subform called Child89? Is that it's name?