I have a database that manages assets at a refinery. I am a very inexperienced Access user but am making my way along very slowly with help from the web and others. What I would to add to my database is the functionality to track my daily progress through prompts that will build a table with user input data. The table has been created with 3 fields: a date field which I would like to auto-populate with the present day the query is initiated, a number of "tags" entered that day, and a long text description of other work performed. I would like a button to be placed on my main form that when clicked prompts the user with "How many tags have you entered today?" then once a number is entered the next prompt ask,"Is there anything else you helped with today?". The information input into these prompts would be stored into the table in the respective fields. Obviously the date would auto-populate for that day and so on each time the button on the main form is clicked. Please help. I appreciate any input.
Thanks,
Dave