OpenForm syntax for AfterUpdate Event

P

Petra

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
 
B

Brian Bastl

Petra,

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

Brian
 
P

Petra

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

Brian Bastl said:
Petra,

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

Brian


Petra said:
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
Click to expand...
Click to expand...
 
B

Brian Bastl

What error message is given?


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

Brian Bastl said:
Petra,

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

Brian


Petra said:
My afterupdate event won't compile but returns an invalid argument
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
P

Petra

Incorrect Syntax

Brian Bastl said:
What error message is given?


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

Brian Bastl said:
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
Click to expand...
Click to expand...
Click to expand...
 
B

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


Petra said:
Incorrect Syntax

Brian Bastl said:
What error message is given?


Petra said:
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
Click to expand...
combo
box
from another form isn't working. Any help is greatly appreciated.

Thank you, Petra
Click to expand...
Click to expand...
Click to expand...
 
Top