What fires first Init() or Load()

Does the Init() procedure of a form, fire before the Load() procedure of the form.

I am trying to use a SQL Select in the Load() of a form with a passed form property from a ComboList box [a value set within it's Init()]. I had hoped to initialize the passed property before the Forms Load() event and its SELECT-SQL ran, then optionally let the user select different values in the ComboList box and then have it call the Load() event when the user changes the selection.

I am not sure of the event firing sequence.

Thanks in Advance

Richard

Load() fires first.

The order is remembered by the mnemonic: LISAG

L - Load

I - Init
S - Show
A - Activate
G - GotFocus

You would have to initialize your combobox programmatically in the Init method of your form. Leave RowSource and RowSourceType empty in design time and set them in run-time once you have your parameter in the form's Init.

The selection in the combobox changes the contents of a grid on the form. I had hoped to populate the grid upon opening the form, and then let the user change the combobox list to change/filter the contents in the grid using a SQL-Select.

I had thought it was good practice to have all tables open from within the Load event. I can make a separte SQL method as you mentioned and call it from the init event o fthe form and the InteractivChange event. That way I have only 1 statement populating the grid.

Does that sound like normal practice

Ok, I believe understand except for one thing. The Grid in which I set up programatically, with ControlSource's for each field to be shown, does not refresh once I change the value in my ComboBox. It works when I first load the form, but when I select another value in the ComboBox the grid goes empty.

I have tried to clear the connection to the grid from the table, but it has not worked

This is my Select Method I have created that was to repopulate the grid on the form when the user changed a value in the ComboBox.

What have missed It's as if once the grid is initilized it cannot be updated.

***********************************************
* GET THE DATA FOR THE FORM
***********************************************
IF USED('cAdtype')
USE IN cAdtype
Thisform.grdadtype.recordsource = " "
Thisform.grdadtype.recordsourcetype = 0 &&Table
ENDIF

SELECT ALL * ;
FROM adtype ;
WHERE adtype.booktype = Thisform.booktype ;
INTO CURSOR cAdtype

***********************************************
* GET THE GRID READY FOR THE FORM
***********************************************
Thisform.grdadtype.recordsource = "cAdtype"
Thisform.grdadtype.recordsourcetype = 1 &&ALIAS

Thisform.grdadtype.columncount = 4
Thisform.grdadtype.deletemark = .f.
Thisform.grdadtype.gridlines = 2 &&vertical only

Thisform.grdadtype.Column1.ControlSource = 'adtype'
Thisform.grdadtype.Column1.Header1.Caption = 'Adtype'
Thisform.grdadtype.Column1.Readonly = .T.

Thisform.grdadtype.Column2.ControlSource = 'description'
Thisform.grdadtype.Column2.Header1.Caption = 'Description'

Thisform.grdadtype.Column3.ControlSource = 'rate'
Thisform.grdadtype.Column3.Header1.Caption = 'Rate'
Thisform.grdadtype.Column3.SetAll("DynamicInputMask", "@l$ ###,###,###.##")

Thisform.grdadtype.Column4.ControlSource = 'priority'
Thisform.grdadtype.Column4.Header1.Caption = 'Priority'

Thisform.grdadtype.column1.width = (Thisform.grdadtype.width * .20)
Thisform.grdadtype.column2.width = (Thisform.grdadtype.width * .50)
Thisform.grdadtype.column3.width = (Thisform.grdadtype.width * .12)
Thisform.grdadtype.column4.width = (Thisform.grdadtype.width * .10)

Right before running your select put

thisform.grdAdType = ""

However, I prefer to use a different technique, called 'safe select'. It was discussed here recently few times.

See http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=346475&SiteID=1 and http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1688378&SiteID=1 for example.