Form Design Assistance

  • Thread starter Thread starter Frolickin
  • Start date Start date
F

Frolickin

I am setting up a form to write to a table in an Access
(2003) database in FP 2002.

All forms I have set up prior to now have been simple: any
drop-down boxes have had a limited number of choices,
thus, easy to type in.

The form I am currently working on has a field that
presently has over 400 options. Obviously, that is too
many to type, not to mention it is a dynamic list.

I know I can create a Data Access Page in Access, but I
would prefer not to do that.

So, my question is, how can I populate the drop-down box
in the form with data from a query?

Fro.
 
1. Configure a Database Results Region to display the
400 records you want.
2. On page 4 or the wizard, set the drop-down list to
Dropdownlist - One Record Per Item.
3. Set the Display Values From This Field list to
the name of the query result field that the finished
drop-down box will display (i.e. Employee Name).
4. Set the Submit Values From This Field list to
the name of the query result field that the finished
drop-down box will submit to the Web server. (i.e.
Employee ID).

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
Can this be done from a query? I have been struggling
with this mightily.

Setting parameters on the table (trying to avoid the query
which just does not display) has not produced results.

Fro.
 
Back
Top