Input Box for Listbox

[DubboPete]

Hi all,

Is it possible for my [List38] which contains ("TV", "Newspaper", "Radio",
"Other") to pop up an input box when the "Other" value is selected, so that
the user is required to say what the "other" actually is? The text value is
to be stored in a field called "ReferralSource".

TIA everybody

DubboPete
the newsgroup's 17th Century Goat Herder

 

[Douglas J Steele]

Put code in the AfterUpdate event of the listbox to check the currently
selected value in the listbox, and use the InputBox function when
appropriate.

 

[DubboPete]

Thanks Doug

Can you please point me towards the documentation for the InputBox function,
as this is a new function I was totally unaware of !! Microsoft Help Index
asks me to rephrase my question....sob sob

If I can find the function, I can do that bit! (I'm not that much of a
goat-herder really <g>), but I didn't even know there was that function!!

DubboPete

 

[Douglas J Steele]

It should be in the Help file, or check
http://msdn.microsoft.com/library/en-us/vbenlr98/html/vafctinputbox.asp

 

[DubboPete]

Igonre my last, Doug... I ust worked out it was in VB help, and not Access
help....

d'oh

Goat-Herder