This is a multi-part message in MIME format.



------=_NextPart_000_0011_01C17E80.046D7340

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



Hi



I have a form used to query the db depending on various where conditions 

created from drop down boxes. Records are displayed as continuous forms. 

I am looking for a tidy way to clear the forms record source and so 

removing the record set, I currently do it by asking for a record I know 

does not exist hence returning none but this necessitates a another trip 

to server. What is the standard approach.



Thanks in reply



Andrew

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "AAustin" <plant-tech@x...>

Subject: [access_asp] clearing forms record source





: I have a form used to query the db depending on various

: where conditions created from drop down boxes.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



I understand this bit. You have a HTML form. The user selects various

criteria from the form. This information is used to retrieve some data from

a database and (presumably) write this data to the screen.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

:  Records are displayed as continuous forms.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



This I don't understand...are you still talking about HTML forms? What

exactly do you mean by the above?



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

: I am looking for a tidy way to clear the forms record source

: and so removing the record set.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



This I also don't understand. The "HTML form" doesn't have a record source.

You use code to preset the values of HTML elements. If you don't want the

form to have any value, just don't set a value in the first place.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

: I currently do it by asking for a record I know does not

: exist hence returning none but this necessitates a

: another trip to server. What is the standard approach.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



Why not request the page without specifing a record at all? and just have

the code detect whether a RecordID (or search criteria ) where passed in. If

none were passed in, then just write out a blank HTML form.



Cheers

Ken