good day (IMG:style_emoticons/default/smile.gif)

is it possible that a combo box changing everyday?

for example i have a combo box Day and the values are Monday to Saturday

what if the Day today is Monday and the combo box change into Monday

Thanks for any help (IMG:style_emoticons/default/smile.gif)

What are you hoping to accomplish? What is the reason for this change?
Are you trying pre-select the day value in a combo box? Or are you trying set a default value for the combo box?

It seems to me that, if the goal is to select the current day for this combo box, it's not really necessary to have a combo box at all. You can just return the current weekday to a text box.

Use can use the Format() command to generate a string for the current date: Format(Date(),"dddd")

i have a PC units that might available on the selected day..
im not going to pre select the value in the combo box...
what i mean is to automatically changing the value of the combo box every other day

is it posible? what is the other way to do this

thank you sir (IMG:style_emoticons/default/smile.gif)

Please bear with me here. I am still not sure I completely understand.

A combo box contains a LIST of values, not a single value. So I assume what you want to do is select one of the values in the list, based on the current day.

I also assume this list of values consists of 7 records, one for each of the days of the week (Monday through Sunday).

If you want to automatically select the current weekday in the combo box, you can do that with code like this in the form's current event.



That assumes your combo box actually contains weekday names (e.g., "Monday") and that you want to select those names.

HTH

As David Letterman often has occasion to say,"What?" (IMG:style_emoticons/default/laugh.gif)