List Box Data Source

[Jonathan]

Hi Everyone!

TGIF!!!!!!

I have been trying to find a way to make the contents of a list box on an
input form use the values from a db table. I know how to do this for a
results page but how do I do it for a form?

Tia


Jonathan

 

[Stefan B Rusynko]

To display all values from a table (opened as a DB connection to objRS)

<%
objRS.MoveFirst
Do While Not objRS.EOF
%>
<option value="<%= objRS.Fields("FieldName")%>">
<%=objRS.Fields("FieldName")%></option>
<%
objRS.MoveNext
Loop
%>




| Hi Everyone!
|
| TGIF!!!!!!
|
| I have been trying to find a way to make the contents of a list box on an
| input form use the values from a db table. I know how to do this for a
| results page but how do I do it for a form?
|
| Tia
|
|
| Jonathan

 

[Jonathan]

Thanks for this Stefan,

Can I be really stupid - cos I use the database wizard most of the time or
create a form from sctratch and just select the database from my site list I
am not sure how to use two database sources.

You say "opened as a DB connection to objRS", is there a KB article on this?

Cheers

Jonathan

 

[Kathleen Anderson [MVP - FrontPage]]

How to filter a database query by using a drop-down list in FrontPage
http://support.microsoft.com/kb/235554

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

 

[Jonathan]

Thank you Kathleen - but I am not wanting to get results I am wanting to
populate a list box in an input form, is this easy?

 

[Jonathan]

Hi Kathleen - me again!!!

Scratch that last reply, I have just got the gist - I have copied the field
form a dummy result based on the fields in the table I wanted and then added
the field to the innput form and it work!

Hurrah - thank you!

 

[Kathleen Anderson [MVP - FrontPage]]

You're welcome

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx