Y
ym
Hi
My 'Timesheet' form (form record souce = Timesheet table) has
1) cboName (row source = qryName, can add new name, control source = Timesheet_Name field)
2) txtDate (control source = TImesheet_Date field
It also has an 'Activity' sub-form (form source = Activity table) with
1) cboActivityName (control source = Activity_activity field, Value List of 10 items
2) txtTime (control source = Activity_time field
A 'Timesheet' form entry can have multiple Activity Name/Time entries
When the user enter a Name and Date - record gets created in the table. And then as they select the Activity and enters its Time - it gets created in the table
This form is good for adding new Timesheet.
Is there a way I can modify this form so it is possible to add/edit new/existing record. The user will enter a name and a date, I will use this name/date to search if it exists in the 'Timesheet' table. If yes, find its associated records in the 'Activity' table and display on the forms. If it cannot find the name, then I am creating a new record
Can some one please help me how I can achieve this. Please also elaborate the steps and details - this is my first access project and I am still trying to learn to ropes
Thank you
My 'Timesheet' form (form record souce = Timesheet table) has
1) cboName (row source = qryName, can add new name, control source = Timesheet_Name field)
2) txtDate (control source = TImesheet_Date field
It also has an 'Activity' sub-form (form source = Activity table) with
1) cboActivityName (control source = Activity_activity field, Value List of 10 items
2) txtTime (control source = Activity_time field
A 'Timesheet' form entry can have multiple Activity Name/Time entries
When the user enter a Name and Date - record gets created in the table. And then as they select the Activity and enters its Time - it gets created in the table
This form is good for adding new Timesheet.
Is there a way I can modify this form so it is possible to add/edit new/existing record. The user will enter a name and a date, I will use this name/date to search if it exists in the 'Timesheet' table. If yes, find its associated records in the 'Activity' table and display on the forms. If it cannot find the name, then I am creating a new record
Can some one please help me how I can achieve this. Please also elaborate the steps and details - this is my first access project and I am still trying to learn to ropes
Thank you