Refresh DataRecordset display on Subform Datasheet

[March]

Hello All,

I have question about how to get data in recordset refresh after update.

I'm using VBA write a query to get data from master table insert into temp
table to show on screen by using subform datasheet in order to correct data.
This I don't want user be able to make any changes direct to the master
table.

I have the code on Form_Current( ); to make an update data into master table.

With the temp table, for example

RecID Ticket# Detial
00001 1234567 xxxxxxxxx
00002 1234567 xxxxxxxxx
00003 1234567 xxxxxxxxx

If I change ticket# 1234567 to 1234568, the code I wrote could update data
in master table, but display data like below.

RecID Ticket# Detial
00001 1234568 xxxxxxxxx
00002 1234567 xxxxxxxxx
00003 1234567 xxxxxxxxx

I have subform.requery after docmd.runsql sqlcmd.

It seems to be nothing refresh.

I don't know what to deal with it.

Any suggestion would be nice.

Thank you,

March

 

[March]

I've done with this. Thanks to read my question.


March