wazupchris
Sep 28 2005, 03:08 PM
I used this feature previously in a database.
Now i have a new database but this feature is not working.
In my combo box of "On Mouse Up" option, i put =DropMe() ....i get an error message saying "The expression you entered has a function name that Microsoft Access can't find".
What can't it find?? Any ideas?
-Chris
Jack Cowley
Sep 28 2005, 03:12 PM
Make sure you have the DropMe() function in a module. I do not recognize the function name, so it may be a user defined function. Look at your previous db and see if there is a function called DropMe().
hth
Jack
glue
Sep 28 2005, 03:28 PM
the function is most likely
function DropMe()
on error resume next
screen.activecontrol.dropdown
end function
though I like to use it on the GotFocus Event
hth,
aaron
wazupchris
Sep 28 2005, 03:32 PM
I got it, i forgot to add....
Function DropMe()
Screen.ActiveForm.ActiveControl.Dropdown
thanks Jack.
Jack Cowley
Sep 28 2005, 03:47 PM
I'm glad you found the problem!
Jack
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please
click here.