Add a record to a table through a subform
Posted on 2011-05-10
Another crazy question.
I currently have a subform in continuous forms format on a main form. the subform's record source is a table. Every value in Field1 of that table is exactly the same. Therefore, Field2 and Field3 are the only fields displayed in the continuous forms area (the individual records). Field1 is displayed in a textbox near the top of the subform (instead of listing the same value over and over again in the continuous forms area)
When I want to add a new record to the table through the subform, I'm placing the cursor in the blank row at the bottom of the continous forms. When I do this, the textbox goes blank (obviously because it's tied to Field1 and the new record has no value entered into it yet)
What I need are two things:
1. Keep the textbox populated with the value that is currently in it even if I place the cursor in the 'new record' row.
2. Have the textbox value copied into Field1 of the new record when I create a new record (ie when I type something into the blank row at the bottom of the continuous forms subform)