Hi, I have a problem, maybe someone can help:
I have a Main form and the subform is inside the Main form. They are now linked by the field AutoNo in Main and AutoNo field in subform. (Both of the AutoNo fields are autonumber fields). Main form feed to tbl_Main, Subform feeds to tbl_Subform.
When I open the Main form, the Main form will be assigned an autonumber in AutoNo field. I started to go to the Subform (an continuos form) to enter the new record, then the AutoNO of a record in subform is asssigned. But it is not the same as the one in Main form. I need to make the AutoNo in the new record of th subform match to the one just assigned in hte Main form.
The reason that I need this functiion is because I have a query to do the report combined some data on Main form and some data in the Subform. Main form data of that particular AutoNo that will need to match to the data of the subform belonging to that same AutoNO. In the criteria of that query (under AutoNo field of Subform), I enter as "[FORMS]![Main]![AutoNo]". Under this criteria, if the AutoNo in Subform can not be assigned matched to the AutoNo in Main form, the query will not able to produce the report.
Any advice to resolve this for me to get the report. Thank you a lot.
Catty
I have a Main form and the subform is inside the Main form. They are now linked by the field AutoNo in Main and AutoNo field in subform. (Both of the AutoNo fields are autonumber fields). Main form feed to tbl_Main, Subform feeds to tbl_Subform.
When I open the Main form, the Main form will be assigned an autonumber in AutoNo field. I started to go to the Subform (an continuos form) to enter the new record, then the AutoNO of a record in subform is asssigned. But it is not the same as the one in Main form. I need to make the AutoNo in the new record of th subform match to the one just assigned in hte Main form.
The reason that I need this functiion is because I have a query to do the report combined some data on Main form and some data in the Subform. Main form data of that particular AutoNo that will need to match to the data of the subform belonging to that same AutoNO. In the criteria of that query (under AutoNo field of Subform), I enter as "[FORMS]![Main]![AutoNo]". Under this criteria, if the AutoNo in Subform can not be assigned matched to the AutoNo in Main form, the query will not able to produce the report.
Any advice to resolve this for me to get the report. Thank you a lot.
Catty