Openargs unreliable results 2

[petermeachem]

Access 2003

I seem to be having a problem with openargs not working 'properly'.
In this specific example, formA has 4 columns and calls formB with a value 1,2,3 or 4 to display data for the relevant column. Sometimes this doesn't work as far as I can see and either openargs has the wrong value or possible null (Users just say it didn't work!).

Code on formB is like
Private Sub Form_Open(Cancel As Integer)
Me.Car = Forms!xfrmQuoteMain!xfrmQuoteDetail("Car" & Me.OpenArgs)

I have just read somewhere that this should be in Form_Load, not Form_Open. Is there any mileage in that or where else could the problem lie.

 

[Remou]

It should be in Load. The control is not yet available in Open.

 

[TheAceMan1]

How are ya petermeachem . . .

In the [blue]On Open[/blue] event the form is still in setup. Hence the [blue]Load[/blue] event is better! . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[petermeachem]

Thanks for the prompt replies. I'll move the code. It works nearly always, just the odd time when it doesn't.