Solved New table column not showing in control source

[paul.brisenden]

Hi Guys

Ive added a new column in a table but this is not showing within the control source selection. Am i missing something?

 

[Gasman]

Works for me, either local or linked.
Can you explain your steps?
Have you closed and reopened Access? I did not need to except the db for linked table.

 

[paul.brisenden]

Table is already linked to a form and all boxes in form are bound by control source.
Added a new column within the table and set the format.
opened form in Design view and added a new box
attempted to bound the box in the control source selector
new table column not visible within control source options.
have saved and closed and still not visible.

 

[Gasman]

Can you try and just type in the fieldname instead?
Upload the table and form?

 

[paul.brisenden]

Attempted to manually type the control name - Not working.

Table has new entry
PMI price box with manually typed control source not working
control source is not showing updated table field.

 

[Gasman]

Upload a db with that form and table then?
Use this if private data is in there. In fact do not even need any data, just the table and form?
Edit: Is the table local or linked?

 

[paul.brisenden]

its a local table

 

[Gasman]

Well upload it and the form as something is sorely amiss.
Open a new blank DB and import that table and form. Then just for a laugh, see if it is still doing it before you upload that new DB.

 

[paul.brisenden]

attached below

select VIEW ALL EVENTS.

click Event ID

PMI

 

[paul.brisenden]

SOLVED - there was a hidden Query that i didnt realise i had

 

[Gasman]

View All Events opens frmTotals whose source is Projects?
Just create a form against PMI

 

[Gasman]

Finally found PMISubform which *looks* like your pic.
That form's source is a query as below

SELECT PMI.PMIID, PMI.ProjectID, PMI.ACLPROJNUM, PMI.CLIENTNAME, PMI.JMAN, PMI.ISSDATE, PMI.PMIISSUEDBY, PMI.PMINUM, PMI.REFCLAUSE, PMI.DESCRIPTION, PMI.SIGNED, PMI.DATED
FROM PMI;

No mention of PMIPrice ?
You can only select fields from the form source if the controls are bound.

 

[paul.brisenden]

Finally found PMISubform which *looks* like your pic.
That form's source is a query as below

SELECT PMI.PMIID, PMI.ProjectID, PMI.ACLPROJNUM, PMI.CLIENTNAME, PMI.JMAN, PMI.ISSDATE, PMI.PMIISSUEDBY, PMI.PMINUM, PMI.REFCLAUSE, PMI.DESCRIPTION, PMI.SIGNED, PMI.DATED
FROM PMI;

No mention of PMIPrice ?

solved it. Thanks for the input though.