unwanted data entry

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Big tony - 25 Aug 2004 21:43 GMT

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]; )

Reply to this Message

Allen Browne - 26 Aug 2004 04:58 GMT

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.

Signature

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.

>I have a two field table, where the first fields allows a
> user to choose from a drop down box a list of categories
[quoted text clipped - 10 lines]
> Categories].DiagnosesCategory FROM [Diagnoses
> Categories]; )

Reply to this Message

John Vinson - 26 Aug 2004 06:59 GMT

>I have a two field table, where the first fields allows a
>user to choose from a drop down box a list of categories
[quoted text clipped - 10 lines]
>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)

Reply to this Message

tina - 26 Aug 2004 08:32 GMT

> Are you using a Form? or <yuck, PTOOIE!> Lookup fields?

LOL....John, i agree with you completely, but you're just hilarious. <bg

Reply to this Message

Lynn Trapp - 26 Aug 2004 14:58 GMT

> > 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>

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Reply to this Message

tina - 26 Aug 2004 16:35 GMT

LOL....yeah, i've seen a lot of these ambiguous posts from him re Lookup
fields. <vbg>

> > > 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>

Reply to this Message

Lynn Trapp - 26 Aug 2004 16:58 GMT

> 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>

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Reply to this Message

Douglas J. Steele - 26 Aug 2004 18:42 GMT

> > 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>)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

Reply to this Message

Douglas J. Steele - 26 Aug 2004 21:00 GMT

> > > LOL....yeah, i've seen a lot of these ambiguous posts from him re Lookup
> > > fields. <vbg>
[quoted text clipped - 7 lines]
>
> (sorry, I couldn't think of a good pun, his other media... <g>)

Er, medium... <blush>

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

Reply to this Message

tina - 26 Aug 2004 21:14 GMT

but just once, i think he should come right out and tell everyone how he
really feels about them, don't you? no more of these wishy-washy comments!
<bg>

> > > > LOL....yeah, i've seen a lot of these ambiguous posts from him re
> Lookup
[quoted text clipped - 11 lines]
>
> Er, medium... <blush>

Reply to this Message

Lynn Trapp - 26 Aug 2004 21:09 GMT

> 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.

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Reply to this Message

John Vinson - 27 Aug 2004 21:30 GMT

>> John Vinson tells us
>> Lookup fields are from Satan.
[quoted text clipped - 3 lines]
>
><g> You can be sure he's in the process of coming up with a pun right now.

I've got several... but none of them are suitable for mixed company!
<g>

John W. Vinson[MVP]
(no longer chatting for now)

Reply to this Message

Lynn Trapp - 27 Aug 2004 22:04 GMT

> I've got several... but none of them are suitable for mixed company!
> <g>

As my mother always used to say, "Excuses! Excuses! Excuses!" <g>

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Reply to this Message