I am having a bit of trouble programming a command button on Sesame. I want the command button to search for information in the database that I have created based off specific date ranges, and the post the information in a specific report.

I know that the code needs to start with "On element entry" and something to do with the "Global Value" code. Then, I think that there needs to be some coding with "On retrieve spec open event," and "on form entry" with the "select tree item." I'm not sure, though, how to get the coding right. Sesame's programming manual doesn't give me the whole story--either that, or I'm missing something. Any thoughts?   

Let me clairfy things a bit:

I want to program a command button, using the date range that I specify in two fields on a database form, to search the database, retrieve the records between the specified date range, and then put the results retrieved into a report form.  Does that help?

No, I haven't seen the article to which you refer.  What is the title of it?

Should I be bold and daring in assuming that the article to which you refer is at
http://www.lantica.com/Support/sesame_library.html
and the title of the article is "Programmed Retrieves," or any I missing something here?

Hammer,

I have read your wonderful article in the current Inside Sesame newsletter.  I used your guidelines for "Pick Date Range:n Element Entry" for a new command button that I made, and when I tested the coding for errors, none were found. 

I still needed to program the @PopUpMenu to get the date ranges ("past 7 days," etc.) to work with the command button.  I wrote:

If @Add Then Pick date range[the command button label]=

@PopUpMenu("Past 7 days;Past 14 days;Past 30 days;Past 60 days;Past 90 days", "Select a date range")

as the first three lines of the Pick date range:n Element Entry programming.  When I tested it for errors, the parsing module gave me an error:

Statement or End of File expected
var vRange as String (the first line of the coding I borrowed from your article).  How is that possible? ???