>Thanks for answering back Cetin here the code I put in but it still didn't work. It only worked when exited the form and came back into the form.
>
>
>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('lv_ccn_tbl')
> .pf1.p1.List1.requery
> .refresh()
>else
> messagebox('No Court Case Number to add',0,'Warning')
>endif
>endwith
>
>
>
>however, when I change the code from
>
>requery('lv_ccn_tbl')
>
>to
>
>requery()
>
>then it worked fine. I am concerned about having many views in this form that would automatically get requery if I use requery().
>Using requery('lv_ccn_tbl'), which I prefer, would ensure me that I am requerying the right view, but for some reason its not working that way. Any Ideas.
>
>Thanks
>Nick Patel
Nick,
Then sounds like current alias needs requery. However I'm afraid I couldn't understand the problem well.
Cetin