Set form's property when opening it

[Alan T]

I would like to open a form by setting some properties:
eg. using
DoCmd.OpenForm "frmEmployee", acNormal, , , acFormAdd, acWindowNormal

setting the record navigator visible/invisible

Is it possible?

 

[Andy Hull]

Hi Alan

You can set the navigation properties immediately after opening the form...

DoCmd.OpenForm "frmEmployee", acNormal, , , acFormAdd, acWindowNormal
Forms![frmEmployee].NavigationButtons = True

or in the forms open even... Me.NavigationButtons = True

If neither of these is suitable, then you could use the OpenArgs argument
like...

DoCmd.OpenForm "frmEmployee", acNormal, , , acFormAdd, acWindowNormal,
"ShowNav"

And then test for this in the forms open event...

If Me.OpenArgs = "ShowNav" then
Me.NavigationButtons = True
Else
Me.navigationButtons = False
End If


Regards

Andy Hull

 

[Alan T]

Hi, yes it works to make the Navigator buttons visible.

Can I also configure the buttons visibility?
I want to allow the user navigate the records but not add records.
Can I disable the * button?

Hi Alan

You can set the navigation properties immediately after opening the
form...

DoCmd.OpenForm "frmEmployee", acNormal, , , acFormAdd, acWindowNormal
Forms![frmEmployee].NavigationButtons = True

or in the forms open even... Me.NavigationButtons = True

If neither of these is suitable, then you could use the OpenArgs argument
like...

DoCmd.OpenForm "frmEmployee", acNormal, , , acFormAdd, acWindowNormal,
"ShowNav"

And then test for this in the forms open event...

If Me.OpenArgs = "ShowNav" then
Me.NavigationButtons = True
Else
Me.navigationButtons = False
End If


Regards

Andy Hull

I would like to open a form by setting some properties:
eg. using
DoCmd.OpenForm "frmEmployee", acNormal, , , acFormAdd, acWindowNormal

setting the record navigator visible/invisible

Is it possible?

 

[missinglinq via AccessMonster.com]

Again, in the forms open event... Me.ButtonName.Visible = False

 

[Andy Hull]

In the forms open event...

Me.NavigationButtons = True
Me.AllowAdditions = False

will allow navigation but not allow new records (it greys out the *)

Regards

Andy Hull

Hi, yes it works to make the Navigator buttons visible.

Can I also configure the buttons visibility?
I want to allow the user navigate the records but not add records.
Can I disable the * button?

Hi Alan

You can set the navigation properties immediately after opening the
form...

DoCmd.OpenForm "frmEmployee", acNormal, , , acFormAdd, acWindowNormal
Forms![frmEmployee].NavigationButtons = True

or in the forms open even... Me.NavigationButtons = True

If neither of these is suitable, then you could use the OpenArgs argument
like...

DoCmd.OpenForm "frmEmployee", acNormal, , , acFormAdd, acWindowNormal,
"ShowNav"

And then test for this in the forms open event...

If Me.OpenArgs = "ShowNav" then
Me.NavigationButtons = True
Else
Me.navigationButtons = False
End If


Regards

Andy Hull

I would like to open a form by setting some properties:
eg. using
DoCmd.OpenForm "frmEmployee", acNormal, , , acFormAdd, acWindowNormal

setting the record navigator visible/invisible

Is it possible?

 

[Alan T]

Thanks.
That is what I want.