I want the user to enter a store name in a table via a form. I then need the store name to be entered as a new field in the design view of a second table as a yes/no field. Is there vb code that can do this?

Help would be appreciated

Mgordon50

Welcome to Access World Forums...

First of all, what you are describing flies in the face of normalization rules. You should not be creating fields based on store names. You should be thinking in terms of adding ROWS.

See here for more on normalization:
http://support.microsoft.com/kb/283878

And, you might post your table structure so we can help you work out the best design. This current method you propose is NOT good and will only cause you pain in the future.

I undertand your point but...

What I am trying to do is to have a table where competitor locations are the rows and my stores are the columns. The user would check off the columns for the stores that are effected by the competitor location
store 1 store 2 store3 store 4
competitor 1 N N Y Y
competitor 2 Y N Y N
competitor 3 N Y Y N

The user will be adding new competitors via a form / table and I need a way to for the user to also add a new my store with out going into the design view of the table.

Thanks,
mgordon50