Received: from relay.flex.ro (ns.flex.ro [193.230.255.2])
	by postgresql.org (Postfix) with ESMTP id 1EEBF47589D
	for <pgsql-interfaces@postgresql.org>;
	Sun, 21 Jul 2002 11:27:33 -0400 (EDT)
Received: from flex.ro (teo.flex.ro [193.230.255.11])
	by relay.flex.ro (Postfix) with ESMTP
	id 0F24457DDF; Sun, 21 Jul 2002 18:30:47 +0300 (EEST)
Message-ID: <3D3B362C.50208@flex.ro>
Date: Sun, 21 Jul 2002 18:31:08 -0400
From: Constantin Teodorescu <teo@flex.ro>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020605
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: jlt@wvinter.net
Cc: pgsql-interfaces@postgresql.org
Subject: Re: pgaccess: Form's Query usage
References: <3D3A996B.123.133E85@localhost>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200207/119
X-Sequence-Number: 2928

John L. Turner wrote:
> Could any one give me an example of how to use the 
> Query, that can be setup in:
> 	 pgaccess FORMS
> 
> eg. how can I display the rev_date, in a text  box
> in my FORM with a Query that  is from a table in the Current DB 
> Query = SELECT rev_date FROM revisions ORDER BY rev_num
> 
> Thanks to anyone, very much!

There is a 'formdemo.sql' script file that builds a database (formdemo) 
that contains a small example of a rolodex using forms and query.

Did you tried it?

teo