Editing tabbed Form

[PippinsMama]

I have a tabbed form and I found I needed to add some new fields to it. It's a new database so there aren't very many records at this point. The form is created from one table. When I first created the form, it works wonderfully. I added one record and then realized I needed additional information. I added new fields to the table and then opened the form in design view to add new fields to the form. Now when I open the form, I am not able to add any data to those new fields. It shows #Name? and won't let me input any information. Please help. I really don't want to recreate the entire form again, which is what I did last time I had to add new data.

 

[thechazm]

Did you check your control source on those controls that show #Name?

If you are selecting the data from a different table then what your current form is looking at you can also recieve this. To correct it update the relationships between the tables and modify the recordsource of your form to a sql query and select both tables. Then add the fields you need to be used on the form.

That should correct the issue.

 

[PippinsMama]

I will check the source for the #name?. I am only using one table for all of the data, that's why it's confusing me.
*edited to add that the source is the field from the drop down for the table the form is based on. So now I am still confused.

 

[PippinsMama]

Ok, I copied and pasted the form. Then I went in and did an SQL (even tho there is just one table). And now it works. Still not sure how that happens, but at least the form works.

 

[thechazm]

Sounds like the field was not being updated to the forms recordset somehow. Thats weird but glad you got it working.