>I have a form with textboxes and listboxes linked to multiple different views. When I do the following:
>
>
>with thisform
>if !empty(.pf1.p1.T1.value)
> insert into lv_ccn_tbl (ccn, ccn_link, ccn_stamp) ;
> value (alltrim(.pf1.p1.T1.value), .hldid, datetime())
> tableupdate(.t.,.t.,'lv_ccn_tbl')
> lc_id = .hldid
> requery()
> .pf1.p1.List1.refresh()
>else
> messagebox('No Court Case Number to add',0,'Warning')
>endif
>endwith
>
>
>insert into a view and then requery and refresh on listbox control, my new added entry does not show up. If I click on the listbox, then the entry will showup. How can I get the added entry to show up immediately in the listbox without the user having to click on listbox for the entry to showup? Also when I use requery(), does it only requery the lv_ccn_tbl view or does it impact my other view in the form also?
>
>Thanks in advance
>Nick Patel
Nick,
Try .List1.requery instead of refresh.
There what requery() requeries is obcure. It would requery whatever the current alias is. Better use it like :
requery('lv_ccn_tbl')
Cetin