My field is not found in Control Source List

[eemiller1997]

This is driving me nuts. I hope someone can help me.



I have an access database where I have added a new field, but I cannot find the name of that field in the Control Source list to link it from where the data will be entered. It IS in the table, too. Why in the world is it not working.

I will explain further for clarification.

A user enters a New Job Opening into the form for New Job Opening. Later, a user enters a New Interview in the New Interview form.... when they enter the job opening number into the job opening number field, it auto-populates the other information previously entered into the New Job Opening form into an area within the New Interview form. I have made sure the new field is in the table for the New Job Openings table.

I can post screen shots if needed.

Thank you for your help.

[orange]

Please post screen shots, or a copy of your mdb with no personal or confidential info.

[ssanfu]

I have an access database where I have added a new field, but I cannot find the name of that field in the Control Source list to link it from where the data will be entered. It IS in the table, too. Why in the world is it not working.

Is the record source for the form a query???
If so, once the field is in the table, you must modify the query(s) by adding the field to the query(s).

[eemiller1997]

I do not know if this is a query, but here are the screen shots.

First, here is a screen shot of the New Job Opening form that contains the Accounting Distribution field. This is where the content will originally be added to the database.



Wow, these are so small.


Next is the screen shot of the New Job Openings Table Design View where Accounting Distribution can be seen.



Next, is seen the New Interview in Design View. When the person enters the job opening number into the Job Opening # field, the rest of the information seen in this screen shot automatically populates from the data that had previously been entered into the New Job Opening form. (The rest of the New Interview form wasn't included in this screen shot). As you can see, it now says "unbound"




The final screen shot is of the the Properties diaglog box for the Accounting Distrubtion field, that currently says "Unbound", and, you can see, the control source is empty because I cannot find the Accounting Distrubtion field in that list.



Thank you for your help.

[ssanfu]

Open the form "F_Job Openings" in design view.
Open the form properties dialog box.
Click on the "DATA" tab.
What does it have for "Record Source"? It must be a query since the field name doesn't appear in the "Control Source" dropdown.
Add the field to the query.
Save.
Edit the "Control Source" for the control on the form.
Save.
Open the form.

[eemiller1997]

I have done that and am attaching the screen shot. I don't see the "Record Source" under the Data tab.

[ssanfu]

That is the properties for the control.

Click in the square box in the upper left of the form window, then open properties. (See attachment)
Or close the form, then open it in design view. Before doing anything else, click on the properties button in the tool bar.