Need help on VBA! Please!# Database - 数据库
l*u
1 楼
Access expert help!!
Support I am going to fill in a Form, there is a number(PhoneNumber) that I
would like to check if the record of this number exists in my link table? If
so, just go ahead to append to A table, if not, then just pop-up a message and
append to B Table. The following is my code:
Private Sub WTN_AfterUpdate()
Dim rsp
Dim Cur_DB As DAO.Database, WTN As DAO.Recordset
Set Cur_DB = CurrentDb
Set WTN = Cur_DB.OpenRecordset("Select * from LinkTable where = ;")
If WTN.RecordCount <>
Support I am going to fill in a Form, there is a number(PhoneNumber) that I
would like to check if the record of this number exists in my link table? If
so, just go ahead to append to A table, if not, then just pop-up a message and
append to B Table. The following is my code:
Private Sub WTN_AfterUpdate()
Dim rsp
Dim Cur_DB As DAO.Database, WTN As DAO.Recordset
Set Cur_DB = CurrentDb
Set WTN = Cur_DB.OpenRecordset("Select * from LinkTable where = ;")
If WTN.RecordCount <>