I’m looking for somehelp/advice on the best way to achieve the following .
The database contains a single table to record daily sales data - only one record per date is allowed – so the date field is set as the pk.
The user wants to enter sales data via a form for a specific date, using the date picker (ie; as per the date control on the form - Access 2007)
When the user selects a date using the date picker on the form there are two possibilities;
a) Data has already been recorded for the selected date – so the form should populate with the existing record – the user can edit (update) the record if required.
b) No Data has been recorded for the selected date – so the form should display a blank (new) record so the new data can be entered and saved for the selected date.
I can easily make a form to display all of the records using the record selector but the user would prefer to use the date picker to select/enter dates into the date field. I’m not sure if the form’s record source should be the table or a query based on the table, and if I should be using a sub form; ( VBA beginner level). Thanks for any suggestions.
The database contains a single table to record daily sales data - only one record per date is allowed – so the date field is set as the pk.
The user wants to enter sales data via a form for a specific date, using the date picker (ie; as per the date control on the form - Access 2007)
When the user selects a date using the date picker on the form there are two possibilities;
a) Data has already been recorded for the selected date – so the form should populate with the existing record – the user can edit (update) the record if required.
b) No Data has been recorded for the selected date – so the form should display a blank (new) record so the new data can be entered and saved for the selected date.
I can easily make a form to display all of the records using the record selector but the user would prefer to use the date picker to select/enter dates into the date field. I’m not sure if the form’s record source should be the table or a query based on the table, and if I should be using a sub form; ( VBA beginner level). Thanks for any suggestions.
