Current Data in a form?

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

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
 
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
 
How do I base the form on a query?

Rick B said:
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
Click to expand...
 
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
 
Back
Top