If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
unwanted data entry
I have a two field table, where the first fields allows a
user to choose from a drop down box a list of categories (from a table). Based on their choice of category, the computer runs a macro (shown below) which gives them a choice of subcategories to choose based on their first choice. In both fields I have chosen limit to list, but somehow the second field is still allowing data entrants to type into the field. How do I stop this madness? (SELECT [Diagnoses Categories].DXCategoryID, [Diagnoses Categories].DiagnosesCategory FROM [Diagnoses Categories]; ) |
#2
|
|||
|
|||
Perhaps the 2nd box already has a value in it, before you change its
RowSource? If so, the solution would be to SetValue to Null when you set the RowSoruce. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Big tony" wrote in message ... I have a two field table, where the first fields allows a user to choose from a drop down box a list of categories (from a table). Based on their choice of category, the computer runs a macro (shown below) which gives them a choice of subcategories to choose based on their first choice. In both fields I have chosen limit to list, but somehow the second field is still allowing data entrants to type into the field. How do I stop this madness? (SELECT [Diagnoses Categories].DXCategoryID, [Diagnoses Categories].DiagnosesCategory FROM [Diagnoses Categories]; ) |
#3
|
|||
|
|||
On Wed, 25 Aug 2004 13:43:51 -0700, "Big tony"
wrote: I have a two field table, where the first fields allows a user to choose from a drop down box a list of categories (from a table). Based on their choice of category, the computer runs a macro (shown below) which gives them a choice of subcategories to choose based on their first choice. In both fields I have chosen limit to list, but somehow the second field is still allowing data entrants to type into the field. How do I stop this madness? (SELECT [Diagnoses Categories].DXCategoryID, [Diagnoses Categories].DiagnosesCategory FROM [Diagnoses Categories]; ) Are you using a Form? or yuck, PTOOIE! Lookup fields? If it's a Form, set the Limit to List property of the combo box to True. If it's a table datasheet with lookup fields... get rid of your lookup fields and build a Form. John W. Vinson[MVP] (no longer chatting for now) |
#4
|
|||
|
|||
Are you using a Form? or yuck, PTOOIE! Lookup fields?
LOL....John, i agree with you completely, but you're just hilarious. bg |
#5
|
|||
|
|||
Are you using a Form? or yuck, PTOOIE! Lookup fields?
LOL....John, i agree with you completely, but you're just hilarious. bg Actually, I think John needs to be just a little bit clearer on what he thinks about Lookup fields. I'm a bit confused on whether he's for them or against them...veg -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm |
#6
|
|||
|
|||
LOL....yeah, i've seen a lot of these ambiguous posts from him re Lookup
fields. vbg "Lynn Trapp" wrote in message ... Are you using a Form? or yuck, PTOOIE! Lookup fields? LOL....John, i agree with you completely, but you're just hilarious. bg Actually, I think John needs to be just a little bit clearer on what he thinks about Lookup fields. I'm a bit confused on whether he's for them or against them...veg -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm |
#7
|
|||
|
|||
LOL....yeah, i've seen a lot of these ambiguous posts from him re Lookup
fields. vbg Me too. I'm gonna have to talk to John about that. Or maybe he's listening in... g -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm |
#8
|
|||
|
|||
"Lynn Trapp" wrote in message
... LOL....yeah, i've seen a lot of these ambiguous posts from him re Lookup fields. vbg Me too. I'm gonna have to talk to John about that. Or maybe he's listening in... g John Vinson tells us Lookup fields are from Satan. Avoid at all costs! (sorry, I couldn't think of a good pun, his other media... g) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) |
#9
|
|||
|
|||
"Douglas J. Steele" wrote in message
... "Lynn Trapp" wrote in message ... LOL....yeah, i've seen a lot of these ambiguous posts from him re Lookup fields. vbg Me too. I'm gonna have to talk to John about that. Or maybe he's listening in... g John Vinson tells us Lookup fields are from Satan. Avoid at all costs! (sorry, I couldn't think of a good pun, his other media... g) Er, medium... blush -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) |
#10
|
|||
|
|||
John Vinson tells us
Lookup fields are from Satan. Avoid at all costs! (sorry, I couldn't think of a good pun, his other media... g) g You can be sure he's in the process of coming up with a pun right now. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
EXCEL Mask for data entry | Bill | General Discussion | 2 | August 17th, 2004 12:51 PM |
Data entry forms and/or subforms | Hugh Crean | Using Forms | 2 | July 8th, 2004 05:56 PM |
Countif with 2 or more data ranges in same column | Doug | Worksheet Functions | 1 | July 4th, 2004 08:57 AM |
Subform data entry | Marion | Using Forms | 1 | July 2nd, 2004 03:50 AM |
Excel Data Entry / Reference Question: Approach? | steve c matco | Worksheet Functions | 1 | September 29th, 2003 04:18 PM |