Solved Passed Parameter Arrives too late? (1 Viewer)

[ClubSean]

I have a "GenericPicker" form that I use to update the genres, directors, and actors associated with a movie record. The code behind
"EDIT CAST" button (for example) is attached.


Everything "GenericPicker" needs is passed from the calling form. Similar code is executed for genre or director editing. Functionality works fine.

I would like to set a custom icon in the "GenericPicker" Title Bar. I know how to set an icon from the Load_Event. I don't know how to tell the form which icon to use. Passing the ".txtEditType.Value = "A" (for Actor) doesn't work since the form is already loaded before the "With Forms" block is executed and therefore any attempt to utilize a "GenericPicker" event (OPEN, LOAD, RESIZE, ACTIVATE, CURRENT) is too late. Can I use anything in the "With Forms" block to trigger an event in the loaded "GenericPicker" form that I can use to set the icon I want.

Passing parameters in the DoCmd.OpenForm are of the "Where clause" type and not appropriate here.

I don't want to go back to 3 separate PICKER's

Comments?

 

[ClubSean]

Thanks guys. I had an epiphany: the key is to use "OPENARGS"

 

[Uncle Gizmo]

I had a similar problem, where a value stored in a form custom property could not be accessed by the form events.

The solution was to create a public function in the form and run that. I named the function "fSetup".

I did a blog about it here:-

Form Load, Activate, Open, Issue, – Form Load Events - Nifty Access

Form Load Events When you first open a form, the following events occur in this order: Load Events, Open, Load, Resize, Activate, Current.... Now you could be forgiven for expecting that a value passed into a form would be available for the form's events to use. However it's not! These videos...

www.niftyaccess.com