hi xCav8r, tks for your good suggestion.

However, i encountered another related headache, i use a sub-form inside a form (Form_Labor) to display portion of a myTable's records inside a recordset (myRst) after input a field variable (Combo_ID.Text) but the sub-form seems didn't reflash after the variable accepted thro' a inputbox and still show all records of myTable. (what i want is the sub-form content to display only selected portion of myTable's records thro' an input varilable.)

major coding as below.:

while the subForm's DataSource object property was point to the object (myTable).
(i am not quite sure if i using coding still need point this property to myTable ?? also this property seems didn't accept any variable inside??.)

Any adv. is very much appreciated. !!

   
' declare
' below is a single line 
Set myRst = myDb.OpenRecordset("SELECT *       FROM myTable WHERE myTable.BADGE_NO = '" & Combo_ID.Text & "'")      
myRst.MoveLast
db1.[Form_Labor].Refresh
The above coding seems still work for record writing as the record inside myTable was updated but just i cannot display the last records of those selected recordset.

BR/
beginner