Happy New Year everyone..
If I have a text box on a main form and then I want that value to be displayed in a text box on a sub form.
The sub form is based on a query and the main form is based on a table. If the project has data in the query it displays fine but if a new record is entered into the main form when I click to enter in data in the second form the project number doesn't fill the text box in the sub form as there are no records for it in the query even though i am using the code =[Forms]![frmProject]![Project_No] in the control source for the text box on the sub form.
Is there anyway around this?
If I have a text box on a main form and then I want that value to be displayed in a text box on a sub form.
The sub form is based on a query and the main form is based on a table. If the project has data in the query it displays fine but if a new record is entered into the main form when I click to enter in data in the second form the project number doesn't fill the text box in the sub form as there are no records for it in the query even though i am using the code =[Forms]![frmProject]![Project_No] in the control source for the text box on the sub form.
Is there anyway around this?
