hidden to viable (1 Viewer)

[eddcole]

hi guys,

I have created a form that does not show other fields until a certain field is updated (after update). you can only fill these out once the first field is used. the first field is a combobox.

My dilemma is that when I recall the form everything is now hidden again and I have to reuse the combobox to see the rest of the data.

Is there any way round this so I see all the data when I recall the form.

Cheers in advance

edd

 

[arnelgp]

put the value of your combobox to a Tempvars collection:

on your form's load event, check it tempvars exists and set your combobox to it:

private sub form_load()
    If IsNull(Tempvars("anyName"))
        ' if your combobox returns a text
        Tempvars.Add "anyName", ""
       ' if numeric comment the above line and uncomment the ff line
       ' Tempvars.Add "anyName", 0
    Else
        Me.yourCombobox = Tempvars("anyName")
    End If
end sub

and on your forms unload event:

private sub form_unload()
    'if your combobox is text
    Tempvars("anyName") = Me.yourCombobox.Value & ""
    'if numeric
    Tempvars("anyName") = Nz(Me.yourCombobox, 0)
end Sub