adding new field to a table

[yogi]

I just added a new field into a table. when i try to used in the vb code (me.test as a example) the field doesn't show up in the list when i say me. . i HAVE NO IDEA WHY.

Doesn't anyone has a idea why?

thanks for your help.

 

[boblarson]

Me.
is only good for referencing within code on the current form, or report. If your code is on the form, then you would need to change the form's recordset to include that newly created field so that it would be accessible. And if your recordsource is the table and not a query, while you wouldn't need to add the field, per se, you would have to requery (actually you'd need to requery the form for either).

 

[yogi]

if i add the field in the design mode should that field appear on the form.

this problem happen to me twice and I don't know why.

I'm a new in access, so talking about record set still having a problem to understand that.

if I could ask another question. what is the best way to add a new record without using sql insert?

 

[boblarson]

what is the best way to add a new record without using sql insert?

use a bound form.

Plus, given your stated lack of experience, I would say that your database isn't properly designed if you are needing to add a field on the fly. Your database is probably not properly normalized (there's a lot of info here on that, search using normalize / normalization).

 

[yogi]

sorry if you misunderstand my question.

I,M been using foxpro for a long time so i'm used to do thing a bit different.

How do you add a new record to a table?

 

[boblarson]

Ah, you don't need to add a "field" (which is the column itself), you need to add a record (row of data, which could be just one value for a field).

Use bound forms. A bound form automatically connects with the table, so you can scroll through all of the records, add or edit records, etc.

The easiest way to create a bound form is to use the new form wizard.