Found it
Since I found the answer I'll post it.........
2) Adding New Fields to a Form or Report
The tip this week covers a question I am asked at regular intervals. The following is the basis of the question asked:
Question
Once I make a form and base that form on a table(s), then later on I decide to add another field to the table; this field is not showing up in the field list on my form. Why not? Do I have to completely rebuild the form every time I add a new field?
Answer
The problem with both forms and reports is that if you add fields to your table, these are not then automatically added to the query that underlies the form or report - you have to do this manually.
You may not even realise your form or report is based on a query and, to confuse you even more, the query does not exist in the Query Object section of the database. What happens is that if you follow the Wizard to build a form or report based on more than one table, Microsoft Access automatically builds a query to base the form or report on and then stores this query with the form.
To manually add a field to this query:
Open the form or report in Design view;
Open the properties to the form or report by right clicking in the grey square on the upper left-hand side of the form or the report (where the two rulers meet), then selecting 'properties' from the drop down list.
With the properties window open, click on the 'Data' tab then, next to 'Record Source', click on the '...' button. This will open the query the form or report is based on.
Add the new fields by double clicking on them.
Close and save the query.
Your fields should now be in your field list.
