RE: [AccessDevelopers] Drop down prompting for info to be captured

Tue, 13 Dec 2005 12:54:47 -0800

Just add a textbox for the "Other" person's name.  You can enable/disable it based on the dropdown selection.  In your dropdown's AfterUpdate event:
 
Me.txtOtherPerson.Enabled = (Me.cboItems = "Other")
 
 
You could also do an InputBox when "Other" is selected, I suppose. 

Tom Oakes
Personal PC Consultants, Inc.
[EMAIL PROTECTED]
503.230.0911 (O)
402.968.6946 (C)
734.264.0911 (F)



From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Joe
Sent: Tuesday, December 13, 2005 11:56 AM
To: [email protected]
Subject: [AccessDevelopers] Drop down prompting for info to be captured

Hey guys I was wondering if anyone could help me out with a task my
manager wants me to do.  We have a DB that I am creating and it has a
drop down list with 4 items (Site, BD, Site&BD, Other)

I want it to have when Other is selected pop up a text box that can
capture a name of the "Other" person that is data entering in the
info.

Any suggestion on how to do this?  








Please zip all files prior to uploading to Files section.


YAHOO! GROUPS LINKS



Reply via email to