Linking Forms

[UT227]

I have a form with a button linked to another form using the EmmployeeID to link the forms. I had it open to a new form so I can enter a new record. The EmployeeID did not appear, so in the EmployeeID properties in the Control Source, I linked that number (=[Forms]![EmployeeF]![EmployeeID]). So, when I use the button to open that form it gives me a new form and the EmployeeID is in that field. However, when I save the record, the EmployeeID isn't saved. It shows 0. Ideas?

[Missinglinq]

Using

=[Forms]![EmployeeF]![EmployeeID]

in the Control Source means that the Control, on the secondary Form, is Unbound, hence it's not Bound to the Table. To be Bound to the Table, and saved, the Control Source has to have the Field in the underlying Table, not an expression.

If New Records will always be entered in this fashion, i.e. with the primary Form open and the EmployeeID entered, on that Form, you could use the

=[Forms]![EmployeeF]![EmployeeID]

in the Default Value Property on the secondary Form.

Alternatively, when opening the second Form, you could pass the EmployeeID in the OpenArgs parameter of the OpenForm command, then retrieve the OpenArgs in the OnLoad event of the secondary Form and use it to assign it to EmployeeID in that Form.

Linq ;0)>

[UT227]

Linq,
Thanks for the suggestions. I tried the first option. I put that expression into the default of that field in the secondary form. It still did not save it to the table. I'm not sure how to do the second option.

[Missinglinq]

Did you remember to delete

=[Forms]![EmployeeF]![EmployeeID]

from the Control Source of the Control, on the secondary Form, and selected/entered the name of the Field, in the underlying Table, that you want it saved to?

And using it in the Default Value will only populate it for New Records, not for existing Records. If you have many actual Records already loaded, you'd have to do a one-time Update Query to populate the field for those existing Records.

Linq ;0)>

[UT227]

Linq,
Yes. I deleted it from the Control Source in the secondary form. I apologize for my not understanding. I didn't understand this, "and selected/entered the name of the Field, in the underlying Table, that you want it saved to?"

[UT227]

On the secondary form in the EmployeeID field control source, I put in the EmployeeID. With that default expression, it saves exactly like I want it to.

[Missinglinq]

Glad we could help!

Linq ;0)>