how to refresh a form block?
hi all,
i have a master block and detail block on my form.. the query source of my master block is actually a view that joins a main table and a lookup table... when the form commits, i created a stored proc to update the record in the lookup table..( relation of the main and lookup table is one to one.).. when the form commits, i want it to reflect the changes made and update or refresh the screen.
i've read a few similar threads and every one is saying there's no such thing... but maybe there might be a work-around of some sort.
i'd appreciate any help.
allen