>>>>>>>| Also, with Insert, your record pointer may not be set to the new record.
>>>>>>>
>>>>>>>Can you be more specific about this ?
>>>>>>>
>>>>>>>bye,
>>>>>>
>>>>>>Sorin, if you're working with a single table and do a SQL Insert, then your record pointer is moved to the new record. However, if you're working in the Child table of a parent/child relation then after the record is inserted, during the form refresh, the child record pointer may be re-set, depending on how your refresh() code is written. For example if you SELECT the parent record, then the record pointer in the Child table will go to the FIRST matching record.
>>>>>>
>>>>>>HTH
>>>>>>Barbara
>>>>>
>>>>>Also, if you are inserting a new record into the parent, the record pointer will go to a 'phantom' record in the child. Best bet I've found on adding new records to Parent/Child is immediately after inserting into the Parent, insert into the child(ren) with the new ID.
>>>>
>>>>
>>>>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.