How do I use a Formfield value in a database query on another page?

chrispl

New Member

Join Date: Jul 2005

Posts: 4

11th Jul 2005

Hi, I've followed the instructions on the link below on Password Protection and FrontPage.

http://www.frontpageworld.com/tipsan...ndtricks12.htm

Everything works well. It prompts me to login, but what I want to do is then use the username entered on the previous screen, in a database results query.

something like ....

WHERE [managercode] = "username entered on previous screen"

but I just can't get the syntax correct, or even know if it's possible.

Can anyone help please? Thanks in advance, Chris.

« import file update | In FP2002, How Can I Creast a Text Box to Insert Into a Column of Text; Like Seen in Magazines »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Syntax for referring to a Me.FormField w/ "FormField" code generat	=?Utf-8?B?TGVv?=	Microsoft Access VBA Modules	0	20th Oct 2007 04:47 AM
How do I use a Formfield value from a previous page, in a database query on another page?	Chris Plant	Microsoft Frontpage	1	12th Jul 2005 10:58 PM
Re: How do I use a Formfield value in a database query on another page?	Stefan B Rusynko	Microsoft Frontpage	2	12th Jul 2005 09:55 AM
How to return a single value from a query into a formfield?	Mike @ XS4ALL	Microsoft Access Form Coding	4	24th Jul 2003 10:22 PM
How to return a single value from a query into a formfield?	Mike @ XS4ALL	Microsoft Access Queries	5	24th Jul 2003 10:22 PM