>>>Mandy,
>>>First of all never a pain. Many ways and places to do it in fact but for your detailed case it could be like this :
>>>
>>>..
>>>do form form2
>>>thisform.cmbATName.requery()
Cetin
>>
>>I tried this by putting the following code in my FORM1 'Add a new contact' button's Click method:
>>
>>DO FORM addcont
>>*!* refresh lists on return
>>thisform.pfAgyCont.pContacts1.cmbATname.requery()
>>thisform.pfAgyCont.pContacts1.cmbCOname.requery()
>>thisform.pfAgyCont.pContacts1.cmbCPCname.requery()
>>
>>But the lists aren't being refreshed until I close the form and open it again. Any ideas where I can look to make this work? Never easy! ;) And I really appreciate your willingness to help!
>>
>>Mandy
>Mandy,
>Is table buffering on ? SQL would only show tableupdated ones.
>Cetin
Cetin,
Nope. There's no table buffering going on in my form or my table which is the source of the lists.
Don't know if this helps, but my lists use a field from some views (one view per list) and the SQL record source is:
SELECT trim(first)+" "+trim(middlei)+" "+trim(last) AS name, persid FROM Person WHERE acode=caid ORDER BY last INTO CURSOR cPerson
Any other thoughts? (other than telling my users to close and open the form whenever they add a new contact ;)..)
Mandy