UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> =DropMe()    
 
   
wazupchris
post 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
Go to the top of the page
 
+
Jack Cowley
post 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
Go to the top of the page
 
+
glue
post 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
Go to the top of the page
 
+
wazupchris
post 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.
Go to the top of the page
 
+
Jack Cowley
post 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 the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 20th May 2013 - 03:29 PM