How to display default value on Combo Box?

[myaccess2000]

Hi,

I have a table that contain Name and Sections. In this form, i am allowing people to change the section to one of them in the available list in the combo box which came from a list of sections. But before that, i would like to display the default value of section before the user change the value. When the mouse scroll or running through the record, it should display accordingly to the value in the table.

I have put the control source as section and it displays only blank. What do i need to do in order for the user to be able to see her default section's value? Sorry that i am a new bird to this.

Regards
irene

 

[Darrylles]

Hiya,

You have a 'Default Value' property in the 'Data' tab for combo boxes - place your value in there.

Make sure the case is correct or it won't find it.

You are obviously displaying a blank or new record for this to happen, I think that this MAY cause a problem in that if the user decides to leave the form without saving then Access will throw an error (because you've 'edited' the record by automatically adding a value to a field).

this is easy to work around, but post a new question if it comes to that.

Regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[myaccess2000]

Hi,

It doesn't seem to work. I think i have to phase my question again. In the combobox name section, i need to put in things like All, account, payroll..etc. Then in my table i have this record section "account". So i will put "account" as my default text and there is still a list in my combobox. So in short, i need to view my current record first before i proceed to change my record and this combo box give me a choice for me to choose from.

Hope u can help me how to go abt doing that.

Regards