Input Field within a DRW dropdown

[Motty]

Hi,
I'm trying to come up with a way that I can have a DRW with multiple
selections showing on the screen and another input field that would be
'associated' with the same line in the DRW.
I have the DRW with the multi-selection working OK and have a posting
loop that adds each selected line to the database. Now I want to give
the user an option to select an item from the DRW and add a value too,
the value entered would be added to another column in the database
associated with the tagged DRW field.

Is this possible?

 

[Thomas A. Rowe]

Yes, this is possible, but requires custom coding.

In your current dropdown add an option of "Other" and call the field that
you want the user to use "Other", etc.

Then on your db update page, test for Other and if True then use the value
from the form field called Other.

<%
If request.form("dropdown") = "Other" then
UserDefined = request.form("Other")
Else
UserDefined = ""
End If
%>

Use UserDefined to update the field in the database

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

 

[Motty]

Thanks for the advice.
I think I'm missing one part - how to create an OPTION field that
would repeat with the value found in the DRW and will be associated
with each record in the DRW.
I can add a field in the DRW but it does not repeat. I have the DRW
field set to allow a multiple selection.

Thanks

 

[Thomas A. Rowe]

Motty,

I don't use the DRW, but there is an option to build a drop down menu from
the records. Someone who uses the DRW can help you with the steps required.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================