>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

Hi Nick
when you issue REQUERY() , then any view must be in use . So if current view lv_ccn_tbl is open , issue REQUERY() , then that perticuler view only will be requery .

REQUERY([nWorkArea | cTableAlias])
if you do not mention [nWorkArea | cTableAlias] , then data for the SQL view open in the currently selected work area is retrieved.

so you do not have to worry for other views.

Bye
Mihir