What is the VBA for opening a blank Form by dbl-clicking a field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I used the Book Collection template on the Microsft website to begin building
a db. In that template, there is the ability to double-click on a drop-down
field and pull up a blank form for adding new drop-down values. I have tried
duplicating the double-click event procedure to use it elsewhere, but I get a
"You tried to assign a Null value to a variable that is not a Variant data
type" error message. The key to the form I hope to have opened is an
autonumber data type. Any suggestions are welcome.
 
Instead of finding the template, downloading it, setting it up, finding the
code, and trying to guess what you did differently, I'll suggest how you
start to debug your problem:

Run the code in an unmodified version to ensure that it works. Run your copy
of the code to ensure that it doesn't work. Carefully, as carefully as
porcupines make love, examine the original and your code to determine what
you did differently -- clearly something is different if it works in one
place and does not in the other. If you use the stop on error option, it
should stop on the very instruction that causes the error message.

Larry Linson
Microsoft Access MVP
 
Back
Top