refreshing controls..

[keybearer]

hi.. i need some simple help here.. how do i refresh comboboxes, tectboxes or listboxes? lets say i have an option group where if the option is selected, a combobox/textbox is enabled. after selecting something from the combobox, and then choosing another option without doing any other actions.. i want the combobox to clear as if i've never selected anything from it, or return to the default value..

 

[itsmarkdavies]

To reset a Combo Box after you have made a selection from it you can use :-

Forms!frmPERSON!cboPERSON = Null


To refresh the data in a Combo Box you can use :-

Forms!frmPERSON!cboPERSON.Requery

Hope this helps.