>>>| 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