I’m looking for suggestions on the best way to achieve the following ;
The database contains a single table to record daily sales data.
One record per date is allowed – so the date field is set as the pk.
The user wants to enter the sales data using form by selecting the date, (using the date picker 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 options;
a) Data has already been recorded for the selected date – so the form should populate with the existing record – the user can edit 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 know i can easily make a form to display all of the records using the record selector but the user wants to use the date picker to select records.
I’m not sure if the form’s record source should be the table or a query based on the table ( should i be using a sub form?); ( VBA beginner level).
Thanks for any suggestions/help.