Variables in a form (1 Viewer)

[Danielf]

I have two problems with variables in a form
with record source:
1) I would like to assign a value to a combo
box -like for example Dmax of a field;
Where shall I write the code so that when
I am opening the form , it is performing
the Dmax and gives this value to the Combo box; I have tried "before Update" but it
doesn't work.

2) I have the following code
Dim abc As String
abc = Me![Combo box]

so that the variable abc should receive the value of the combo box but it doesn't work.

Thanks for help

Daniel

 

[Travis]

1) Form_Load Event / or Form_Current Event (use Current if you will be going record to record)

2) Combo boxes AfterUpdate Event

[This message has been edited by Travis (edited 03-16-2000).]

 

[Danielf]

Hi Travis,

Thank you very much, it works

Daniel