adding a new field to a table through a form

[sunspot11]

hihi...

need help ...i dun know how to add a new field into an already existing table by using a form..
eg.. i got a table "tabCountry" with applications and countries involved... but now i need to add another country to the table...
how can i use a nice form to add the country and not to go directly to the table to add..

thks thks

 

[mas5]

What have you tried so far? You can create a simple form by using the form wizard and selecting your tabCountry as the table. Is that would you need?

 

[sunspot11]

thks..mas5

what i need is that i need to add an additional new field (NOT a new record)...say a country,india, into the original table...but wan to do it by using a form...

how to go abt doing it...

thks thks...

 

[mas5]

I would think about your table design. Would you have a situation where you would have to add yet another column to your table for each country? Do you need a country table where you keep all the countries and then you select a country for use in your table. Basically being able to add a columnn on the fly is dangerous - I would worry about normalization.

I'm guessing you can add a column in your table using Visual Basic. On exit of entering your new column name you can call a query. If you can write a query to add this new column then you can accomplish it that way. Again, I would be very careful about doing something like that.

 

[lamarw]

Pleawse bear with me on this. Normally we speak of columns and records when we refer to a table. We refer to 'fields' when we are using a form. Now, you mention that the Field you want to enter is new.

Could it be that you want to add a new 'field' to a form and then bind that field to a 'column' in your already existing table? If so, then please see the answer above from mas5 again. This is possible without too much problem.

-Or-

Are you asking how to create a data entry/editing form which you can use to add/edit data to your existing table without having to go to the table every time you add/change/delete data?

 

[sunspot11]

yap..
need to add a new column to an already existing table..

 

[mas5]

Be very careful! I'm guessing that if you want to do this using a form that you might do this often.

Consider adding a new country code table and a country code column to your existing table. You can always display your data in a spreadsheet-like format using Pivot tables.