DRW Drop-down question...

[skc]

I have a table in my database (Access2000) with the
following fields:

Table name: Users
Fields: UserID: Autonumber, Username: Text

I have created a DRW dropdown in a FrontPage form, but I
want the following to happen:

I want the Username to be displayed but the value to be
the UserID.

I have tried and tried fiddling with the coding but it is
not working - can you help!!

This is prob a simple thing - but my head is not
functioning.

Thanks in advance,

skc

 

[Jim Buyens]

On page 4 of the wizard:

1. Under Choose Formatting Options For The
Records Returned By The Query, choose
Dropdown List - One Record Per Item.
2. In the Display Values From This Field dropdown box,
choose Username.
3. In the Submit Values From This Field dropdown box,
choose UserID.

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

 

[skc]

Jim,

Silly me - you are absolutely right!

Thanks.