Current Data in a form?

[Guest]

I have a form that I want to be able to bring up todays information in it
(time sheet database) and i would like the user to be able to change fields
like Day_Out, Lunch_In, ext. How/where will I go to accomplish this.

Thanks for your help.

William Harris III

 

[Rick B]

base your form on a query. in the query, limit the records to the current
date by putting the following under the date field... =Date()


Rick B

 

[Guest]

How do I base the form on a query?

base your form on a query. in the query, limit the records to the current
date by putting the following under the date field... =Date()


Rick B

 

[JohnFol]

Hi William, I think if you want step by step then a NG is not the best forum
for you. This is best tackled with training, or going through some of the
walkthroughs in the help screens.

To answer your question, you would go to the db window, click on Queries and
then New. Base a new query on the table, and add the criteria Rick
suggested. Save the query. Then, on your form, change the Record Source
property to be the name of the query.

Regards