i am trying to use a subform to add data to table. if you look at the access file i have attached you see that i have a form 'frmSearchReasult_Status2' which has a subform called 'subfrmJobStatus'. The main form contains a Job (pulled out using a query) and the subform contains Status of that job, which is basically comments made on the job on different dates.
what i need to do is to be able to add a new status for the job. i tried using a command button, linking to a new form in Dataentry mode but i can't refer to the jobID value in that form (Job ID is the link between 2 tables tblJob and tblJobStatus) and this fiels must definitly be filled otherwise adding to table (tblJobStatus) won't work.
the allow addition field in subfrmJobStatus properties is set to Yes so it should allow me to add new record in the subform but when the main form 'frmSearchReasult_Status2' is loaded it won't allow me to add a new record!
can some1 be kind enough and take a look at my file and help me out please. i am greatfull for any help guys.
cheers
what i need to do is to be able to add a new status for the job. i tried using a command button, linking to a new form in Dataentry mode but i can't refer to the jobID value in that form (Job ID is the link between 2 tables tblJob and tblJobStatus) and this fiels must definitly be filled otherwise adding to table (tblJobStatus) won't work.
the allow addition field in subfrmJobStatus properties is set to Yes so it should allow me to add new record in the subform but when the main form 'frmSearchReasult_Status2' is loaded it won't allow me to add a new record!
can some1 be kind enough and take a look at my file and help me out please. i am greatfull for any help guys.
cheers
