Newbie in variables

Danielf

Registered User.
Local time
Today, 07:37
Joined
Feb 21, 2000
Messages
103
I have a form without record Source.
I have declared variables -when I am opening the form. (properties on open)
Now I have a combo box in this form.
Which command do I have to write in the combo so that when it is filled with a value, the variable is receiving this value?


In general: after having declared a variable, what is the command to fill it -on screen?
( like in Foxpro the Get or Input command)


Thanks for help

Daniel
 
Access works with variables pretty much like any other control. To assign the value of the combo box to the variable, put the following in the AfterUpdate property of the combo box: [Variable] = Me![Combo Box].

You can assign the variable to any text box using the reverse of above: Me![Text Box] = [Variable]. But if the variable changes by user input, you'll want to be sure to update the control box by using the AfterUpdate property on the field where the change is made.
 
Thanks for the help but it doesn't work.
Daniel
 
It should do - post your code
 
Now it works, I have found my error;
Thanks

Daniel
 

Users who are viewing this thread

Back
Top Bottom