Manually creating new field in form

[AdinConfussion]

Hello,
In my access 97 DB, I've added a new field in a table, and then added the new field in the appropriate form which already uses this table. When I go to set the control source in the properties of the form field, the droplist selection doesn't have the new entry from the table. My form is based on the table without using a query. How do I make the control source list update? Thanks in advance for your help.

- Steve

 

[hermanlaksko]

If your form is based on the tbl directly the new field is there, no doubt, however if you form is based on a query only useing that tbl your new field will only show after you add the new field to that query, as I am sure that you all ready know.

Try basing your form on a query and select all fields and see if you new field does not show in the dataview of that query.

Herman

 

[AdinConfussion]

Thanks for replying, the form is pretty complex, including three subforms and was pre-existing when I came here. Right now I'm playing with a copy of the DB trying to update it, and then modify the actual db when I have some solutions. I created the query with the new field, and then created a simple form from the query, and of course that worked. However, I would like to change the actual db as little as possible. I've gone through all the existing queries in the DB to make doubly sure the form is not based on a query. I think the problem is that the form does not auto update based on the new structure (added field) of the table.

Thanks again,

- Steve

 

[hermanlaksko]

Try checking the recordsource on the form in question, as I belive that this is where your problem lies.

Herman