Where would this data be saved if I wanted to report off of it though?

Tom Oakes <[EMAIL PROTECTED]> wrote:
I don't see any reason to put it in another table.  I would just add a field for it.
 
Tom Oakes
Personal PC Consultants, Inc.
[EMAIL PROTECTED]
503.230.0911 (O)
402.968.6946 (C)
734.264.0911 (F)



From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Joe Fonseca
Sent: Wednesday, December 14, 2005 8:39 AM
To: AccessDevelopers@yahoogroups.com
Subject: RE: [AccessDevelopers] Drop down prompting for info to be captured

How should I make it capture this data?  Should I put an original field in the table or should I create a seperate table to just capture "Other" instance?

Tom Oakes <[EMAIL PROTECTED]> wrote:
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: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Joe
Sent: Tuesday, December 13, 2005 11:56 AM
To: AccessDevelopers@yahoogroups.com
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?  







Yahoo! Shopping
Find Great Deals on Holiday Gifts at Yahoo! Shopping


Please zip all files prior to uploading to Files section.




Yahoo! Shopping
Find Great Deals on Holiday Gifts at Yahoo! Shopping


Please zip all files prior to uploading to Files section.




YAHOO! GROUPS LINKS




Reply via email to