DBRW - more options - default - value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a date field to filter a search. I would like the default start
record to be the current date i.e. today. I can only seem to get a
satisfactory result by putting in a specific date, but then understandably
all refreshes of the result start at that specified date. Leaving the default
blank means all refreshes go back to the first record in the field. How can I
start the results from the current date and maintain the start date after
editing records.
PS I have been able to get the initial submit box to return current date in
the browser. But this does not help with the default upon refreshing the
results.
Solution would be greatly appreciated.
 
Set the initial field value to:

<%=Date()%>

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================
 
Thanks for the response but I am looking for the value to set WITHIN the
wizard set up under 'more options ' - 'default ' . (The one with the
attached HTML 'fp_sDefault=' that cannot be overwritten as it always changes
back to its original upon saving)
I want the results page to always default to todays date.

I am not looking for the value to populate the submission box to start the
query.

Appreciate if you can help further. thanks
 
You might need to learn to handcode instead of using the FP database components.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================
 
Back
Top