OpenForm syntax for AfterUpdate Event

[Guest]

My afterupdate event won't compile but returns an invalid argument error. My
syntax only requires that the form open as a "snapshot". So my current syntax
is:

Private Sub Combo40_AfterUpdate()
DoCmd.OpenForm(frmDimensionLookup).[acPreview]
End Sub

I am not a programmer, but I've been able to program with VB in maximizing
and zooming, but opening this form by entering parameters into a combo box
from another form isn't working. Any help is greatly appreciated.

Thank you, Petra

 

[Brian Bastl]

Petra,

Will this help?
DoCmd.OpenForm "frmDimensionLookup", , , , acFormReadOnly

Brian

 

[Guest]

Thank you Brian. Your syntax does not compile either. Any other suggestions?
Petra

Petra,

Will this help?
DoCmd.OpenForm "frmDimensionLookup", , , , acFormReadOnly

Brian

My afterupdate event won't compile but returns an invalid argument error. My
syntax only requires that the form open as a "snapshot". So my current syntax
is:

Private Sub Combo40_AfterUpdate()
DoCmd.OpenForm(frmDimensionLookup).[acPreview]
End Sub

I am not a programmer, but I've been able to program with VB in maximizing
and zooming, but opening this form by entering parameters into a combo box
from another form isn't working. Any help is greatly appreciated.

Thank you, Petra

 

[Brian Bastl]

What error message is given?

Thank you Brian. Your syntax does not compile either. Any other suggestions?
Petra

Petra,

Will this help?
DoCmd.OpenForm "frmDimensionLookup", , , , acFormReadOnly

Brian

My afterupdate event won't compile but returns an invalid argument

error.
My

syntax only requires that the form open as a "snapshot". So my current syntax
is:

Private Sub Combo40_AfterUpdate()
DoCmd.OpenForm(frmDimensionLookup).[acPreview]
End Sub

I am not a programmer, but I've been able to program with VB in maximizing
and zooming, but opening this form by entering parameters into a combo box
from another form isn't working. Any help is greatly appreciated.

Thank you, Petra

 

[Guest]

Incorrect Syntax

What error message is given?

Thank you Brian. Your syntax does not compile either. Any other suggestions?
Petra

Petra,

Will this help?
DoCmd.OpenForm "frmDimensionLookup", , , , acFormReadOnly

Brian


My afterupdate event won't compile but returns an invalid argument error.
My
syntax only requires that the form open as a "snapshot". So my current
syntax
is:

Private Sub Combo40_AfterUpdate()
DoCmd.OpenForm(frmDimensionLookup).[acPreview]
End Sub

I am not a programmer, but I've been able to program with VB in maximizing
and zooming, but opening this form by entering parameters into a combo box
from another form isn't working. Any help is greatly appreciated.

Thank you, Petra

 

[Brian Bastl]

Hmmm,

assuming you didn't misspell the form name, I'm not sure, since the syntax
provided definitely works for me. Perhaps it's a missing reference problem
?? Just guessing, obviously.

Brian

Incorrect Syntax

What error message is given?

Thank you Brian. Your syntax does not compile either. Any other suggestions?
Petra

:

Petra,

Will this help?
DoCmd.OpenForm "frmDimensionLookup", , , , acFormReadOnly

Brian


My afterupdate event won't compile but returns an invalid argument error.
My
syntax only requires that the form open as a "snapshot". So my current
syntax
is:

Private Sub Combo40_AfterUpdate()
DoCmd.OpenForm(frmDimensionLookup).[acPreview]
End Sub

I am not a programmer, but I've been able to program with VB in maximizing
and zooming, but opening this form by entering parameters into a

combo
box

from another form isn't working. Any help is greatly appreciated.

Thank you, Petra