[belajar-access] acFormAdd, acDialog, Requery erorr di Data Entry Form

Dear warga Milis,
Saya ada sebuah Form dan pada sebuah fieldnya saya set "double click" untuk memasukkan data baru pada sebuah Tabel,
kemudian direquery dgn coding sbb :

 

Private Sub NoTG_DblClick(Cancel As Integer)

On Error GoTo Err_NoTG_DblClick

NoTG = [NoTG]

DoCmd.OpenForm "DATA 2", , , , acFormAdd, acDialog

Me![NoTG].Requery

Exit_NoTG_DblClik:

Exit Sub

Err_NoTG_DblClick:

MsgBox Err.Description

Resume Exit_NoTG_DblClik

 

End Sub

 

Code berjalan mulus, tapi ketika saya rubah Property Form Data Entry menjadi "yes" timbul error dengan comment sbb :

 

"You tried to assign Null Value to a Variable that is not a Variant data type"

 

Bagaimana caranya agar coding diatas tetap berjalan dengan Property Form Data Entry = "yes" ?

Terima kasih...

 

Regards

Hendra

__._,_.___

SPAM IS PROHIBITED

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___