Hello All,
I am trying to get the following to work:
Data input form with the following fields:
1 - CustomerName (combobox from a table)
2 - JobNumber (combobox from a query)
3 - Employee (combobox from a query)
4 - WorkDate
5 - WorkDescription
6 - WorkHours
All the above data is to go into a table called tblWorkHoursInput with corresponding columns
When the data is being entered, most of the time fields 1,2,3,4 will stay the same for multiple entries (with variations in fields 5 and 6).
What I would ideally like to achieve is a way that i can fill all the fields then press a button that would add the corresponding record, and automatically clear fields 5 and 6 so the new data can be inputted before pressing the same button again to add another record. In between entries i could change any of the fields 1,2,3,4 as required and it would then be remembered for the next record.
Any suggestions on the best to go to achieve this?
Any help if much appreciated.
I am trying to get the following to work:
Data input form with the following fields:
1 - CustomerName (combobox from a table)
2 - JobNumber (combobox from a query)
3 - Employee (combobox from a query)
4 - WorkDate
5 - WorkDescription
6 - WorkHours
All the above data is to go into a table called tblWorkHoursInput with corresponding columns
When the data is being entered, most of the time fields 1,2,3,4 will stay the same for multiple entries (with variations in fields 5 and 6).
What I would ideally like to achieve is a way that i can fill all the fields then press a button that would add the corresponding record, and automatically clear fields 5 and 6 so the new data can be inputted before pressing the same button again to add another record. In between entries i could change any of the fields 1,2,3,4 as required and it would then be remembered for the next record.
Any suggestions on the best to go to achieve this?
Any help if much appreciated.