>>>>>I have a combo box that when adding a new record I hide the combo in display a textbox, the textbox is not clearing, it is keeping whatever was in the combo. All my other textboxes are clearing. Help why will these others not clear on a refresh command?
>>>>>
>>>>>Thank You
>>>>>
>>>>>Holly Clawson
>>>>
>>>>Ok, silly question here, what is the Control Source for the Textbox? What is the value of the Textbox? Same question for the ComboBox. Is there a tie between them, if so, what is it? (Can you tell that I've spent WAY too much time answering questions on the phone?)
>>>
>>>
>>>The ControlSource is the same for the combo and text box. The value is none for both of them.
>>
>>Ok, next set of questions. Is the control source a variable, or is it a field in the file. If a variable, are you sure you are setting it to blank ( or whatever it should be for a new record)?
>
>The ControlSource is the field in the table.
Ok....if I'm understanding this correctly:
ComboBox.ControlSource = file1.field1
TextBox.ControlSource = file1.field1
file1.field1 =
[on insert]
but rather than TextBox.Value = , Textbox Value = ComboBox.Value
have you tried the "Bigger Hammer" method and on adding the new record set the Textbox.Value = ?
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place