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