Hi
OK, I would have thought you have found the on click event now.
You say "I am using Access. I have written vba code in Access ", is this code a Function or a Subroutine? ie does it begin with:
Sub MySub()
or
Function MyFunction()
where MySub and MyFunction are your names
If it is a sub, you run it in the OnClick ebvent by simply typing the name of the sub, eg
MySub
If it is a function you need a variable to assign the return value to eg:
Dim X
x= MyFunction()
to do things correctly / efficiently, you should have assigned a type to the function, and a (similar) type to X, eg somthing like
Dim X as Integer
are you running now?
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -
UK