Adding New Field to Old Form

[mfaj5]

Hi Everybody-

I think I have an easy question this time:

I have a form that records contact info for my sales leads. The form needs another field that I just didn't anticipate when I built the db a few months ago. I added the field to the table, but when I went to add it to the form, the field did not appear in the field list in design view. The field list is pointing to the right table, but the new field isn't there.

I realize I am probably making some simple mistake, but I can't figure it out!

Any help would be greatly appreciated.

Thanks as always. This forum is so helpful.

-mfaj5

 

[charityg]

Just to be sure, look at the RecordSource property for the form and make sure it isn't a query that doesn't include your new field.

 

[mfaj5]

I am not even using any queries in this particular db. Any other thoughts? Am I too dumb?

 

[charityg]

Doesn't matter if you have any saved queries. Exactly what is in the Form's Recordsource property?

 

[mfaj5]

The record source is tblAgent. That's the same table I added the new fields to.

 

[charityg]

It's probably something really simple that we're missing. Would you be opposed to sending me a copy of the db? You can take all the data out if you wish.

 

[mfaj5]

I am not opposed to sending it to you at all, as long as you don't laugh. What's the best way to get it to you?

 

[charityg]

send it to
cgaborik@christensenfarms.com
and let me know which field you added that isn't showing up

and I PROMISE not to laugh, I was a newbie once too!

 

[KevinM]

As a newbie then I assume you used the Form Wizard to create your form.

This will use a 'SELECT' statement for your recordsource as opposed to the whole table itself.

i.e. only selected fields. So any new fields added won't show up here automatically.

You need to open this Recordsource from the Form's Properties (click on the 'three dashes' at the end of the box) and then add the field from the query view.

 

[charityg]

He already looked at his recordsource and it didn't contain a select statement. It is set to table tblAgent

 

[KevinM]

So he did. It pays to read ALL posts.

Not wanting to sound patronising but have you scrolled fully down the field list.
Even experienced developers can often overlook something simple like this.

 

[mfaj5]

AHA!

I tried Pat's suggestion and it seems to be working! Thanks so much for the help! You all are so great.

Until next time.

 

[KevinM]

Well that's very strange.

That is something I have never had to do.

What version of Access is it?

 

[mfaj5]

It's Access 2K. Do you think I did something wrong that might mess up my data?

 

[KevinM]

Not at all.

I use Access 2K and have never come across this problem before.

If I add new fields to a table then they always show up in the field list in forms and reports, provided they are based on the table and not a query of any kind.