How to Update Record-set

[eyeseven]

Hi! I have 3 tables,

tbl_type1
-ID
-PO_NO
tbl_type2
-ID
-PO_NO
tbl_bill
-ID
-PO_NO
-Type

I have a combo-box that if i change the to type1 it will copy the PO_NO from tbl_type1, or vise versa.

now my problem is i have a lot of records in tbl_bill, and those 2 table_type is changing, so i don't to go for each record and run refresh everyday to update all records.

Any possible solution?

Thanks so much!

This is the code that i used to copy the data from another table :

If Me.Type = "Variation" Then
    Me.POLOI = DLookup("[POno]", "tbl_variation", "[VarID] =" & [Forms]![Bill_Form]![VarId])
    Me.PODate = DLookup("[PODate]", "tbl_variation", "[VarID] =" & [Forms]![Bill_Form]![VarId])
Else
    Me.POLOI = DLookup("[POLOIno]", "project_table", "[ID] =" & [Forms]![Bill_Form]![ProjID])
    Me.PODate = DLookup("[POLOIdata]", "project_table", "[ID] =" & [Forms]![Bill_Form]![ProjID])
End If