My Assistant
![]() ![]() |
|
|
Sep 28 2005, 03:08 PM
Post
#1
|
|
|
UtterAccess Addict Posts: 190 From: Washington, DC |
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 |
|
|
|
Sep 28 2005, 03:12 PM
Post
#2
|
|
|
Retired Moderator Posts: 37,716 From: The San Francisco Bay Area |
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 |
|
|
|
Sep 28 2005, 03:28 PM
Post
#3
|
|
|
UtterAccess VIP Posts: 894 From: ohio |
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 |
|
|
|
Sep 28 2005, 03:32 PM
Post
#4
|
|
|
UtterAccess Addict Posts: 190 From: Washington, DC |
I got it, i forgot to add....
Function DropMe() Screen.ActiveForm.ActiveControl.Dropdown thanks Jack. |
|
|
|
Sep 28 2005, 03:47 PM
Post
#5
|
|
|
Retired Moderator Posts: 37,716 From: The San Francisco Bay Area |
I'm glad you found the problem!
Jack |
|
|
|
![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 20th May 2013 - 03:29 PM |