Form to Database

[prabhu]

Hello All,

For my daily project updates from all my project members, i have created one form for the users to update the data in the from and to receive the data in access table for my analysis.

My form contains the following data

ID
Date
Time
Data 1
Data 2
Data 3

now, when a user open this form to update the data,
1. how to control the repeated entries from the user in a same day?
2. I created submit button - but what action i shoud use inorder to make my table to receive the data only after hitting submit button
3. When i open the form i see the data which i entered yesterday. how to keep form fields blank everytime i open?

Plese help!!!

 

[ghudson]

1) Give the user a filter command to filter out their records based on their ID and also filter a date field.
2) Give the users a Save button to save their changes to the current record
3) Give the users a New Record button to create a new record for them to complete

Check out the programming for saving, undo and testing if a record is dirty [has been modified but not saved] in my old A Better Mouse Trap? sample which should help your quest.