469,142 Members | 1,141 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,142 developers. It's quick & easy.

Saving First Name field when it is retrieved from another table

I have a database that has in the main table, FirstName, MiddleInitial, and LastName, among other fields.

In my form, the lastname is a combobox that pulls from a POC table. The Firstname and MI are set as
=[lastname]![column](1) etc.
After selecting the last name, the firstname and MI are populated correctly.

However, when I look at the table or any associated query, the firstname and MI are not saved.

Is there a way to save that information in the main form?

Thx
Jason
Apr 4 '13 #1

✓ answered by Rabbit

You need to bind the controls to the fields in the table and use VBA code to populate the value.

If you set the control source to that what you mentioned in your first post, then it will no longer save that data to the table because it no longer knows where to save it.

1 828
Rabbit
12,516 Expert Mod 8TB
You need to bind the controls to the fields in the table and use VBA code to populate the value.

If you set the control source to that what you mentioned in your first post, then it will no longer save that data to the table because it no longer knows where to save it.
Apr 4 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.