Thanks, actually i will only be using access. I will have to pass a variable & based on that i will be executing a sql ... something like this ..
Private Sub TXTnameMASTER_Click()
Dim nn As String
Dim iAffected As Integer
nn = TXTnameMASTER
MsgBox (" selected " & nn)
CurrentDb.Execute...