Autofill Table from a form

[AC5FF]

I am not sure where I went wrong. I thought this would work easy but it's not acting as I expected.

I've got two tables - 1: Address Book; 2: Changes
The Address Book table has all the data.
The Changes table I just have 4 fields; Name (to tie back to Address Book) and Submit, Complete, and Request fields

First off I have View form to select which name. This contains a drop down box so the user can select the name he/she wants to look at. They can then click "View" to open a report that shows them all the info for that particular name selected. OR they can click "Change" to request a change be made to that particular address record.

When they click "Change" I want a 2nd form to open just using fields from the "Changes" table. The form works as expected, it auto populates the Name and Submit fields based on "Like [forms]![Address Select].[FullName]" for the Name field and "=now()" for the Submit field. But when I type information into the Request field and close the form the only data stored is the Request field information. The Name and Submit information for that record remains blank.

Am I missing something simple??

 

[boblarson]

The control sources for the form's controls need to be set to the fields in the table. You can't have a formula there which it sounds like you do.

 

[AC5FF]

I believe I am understanding you Bob. And you are right, if I look at the control source for the two fields I do have a formula in there.

So, my question would then turn to how do I auto-populate that input to the previous form's name selection so that information is stored? I do not want, nor believe is necessary, for the user to have to select which address they want to make a change to. They've already done that on the previous form. Yet, I need to somehow store which address they are recommending a change to.

For example; if a user chooses Joe Smith and reviews his address record they can then click on 'Submit Change' to recommend a change (say the person's phone # has changed). All I want them to do is to type into the 2nd form "New Phone # is XXX-XXX-XXXX" I don't want to make them type in "Joe Smith's new # is ........." If not for ease, then for my clarification that they are recommending a change for this particular Joe Smith and not meaning Joseph Smith - a totally different record.


EDIT: NEVERMIND..
FYI ... I changed the control source back to the table fields. I then put my formula into the 'default value' field. The form now is working as I would expect it to.

Thanks again Bob... You never cease to amaze me with the knowledge you hold!

 

[boblarson]

Glad you got it sorted.