Unbound Text

[Guest]

I have an unbound textbox, RandomMonth, that contains a randomly generated month of the year. I need to move that day to the field on the same form called RandomMonth

How do I do that

SugarBear

 

[Rob Oldfield]

You mean how are you going to set a month equal to a day? Or how you're
going to set a value in a control called RandomMonth equal to the value in a
control called RandomMonth?

It'll be something like me!RandomMonth=me!RandomMonth exectuted just after
you're calculating the random month value.

I have an unbound textbox, RandomMonth, that contains a randomly generated

month of the year. I need to move that day to the field on the same form
called RandomMonth.

 

[Guest]

I have an unbound textbox, RandomMonth, that had code using a DLookup to get a random month of the year. Which it does great.

Now I need to get that random month into a record controlled by the field Month.

That is what I don't know how to do? The field month is hidden, so it can be added on the OnClose event no problem.

Any tips?

SugarBear

----- Rob Oldfield wrote: -----

You mean how are you going to set a month equal to a day? Or how you're
going to set a value in a control called RandomMonth equal to the value in a
control called RandomMonth?

It'll be something like me!RandomMonth=me!RandomMonth exectuted just after
you're calculating the random month value.

I have an unbound textbox, RandomMonth, that contains a randomly generated

month of the year. I need to move that day to the field on the same form
called RandomMonth.

 

[Rob Oldfield]

me.month=me.randommonth will do it.... but if that's all that you're after
then it'd be easier just to bind the randommonth text box to the month
field.

I have an unbound textbox, RandomMonth, that had code using a DLookup to

get a random month of the year. Which it does great.

Now I need to get that random month into a record controlled by the field Month.

That is what I don't know how to do? The field month is hidden, so it can

be added on the OnClose event no problem.