H
HAlx
Hi 
I have an Access ADP bound to MSSQL 2005 EE.
Some updates that I need to do in Access are performed thru server's stored
procedures
Access' form got interface like this: textbox 1(bound to table field and
locked) -
to display current data + commandbutton1 to open some modal form1,
fill it in and update DB thru ADO Command object.
After user executes that update I need to display new data in form1.
All I can think of is to use main form's refresh method.
But it moves from the current record to the very first one.
Is there a way to stay at the current record and get new data for textbox1 ?
I have an Access ADP bound to MSSQL 2005 EE.
Some updates that I need to do in Access are performed thru server's stored
procedures
Access' form got interface like this: textbox 1(bound to table field and
locked) -
to display current data + commandbutton1 to open some modal form1,
fill it in and update DB thru ADO Command object.
After user executes that update I need to display new data in form1.
All I can think of is to use main form's refresh method.
But it moves from the current record to the very first one.
Is there a way to stay at the current record and get new data for textbox1 ?