Delete/Add Fields in a Linked Table

[Gerryw]

Hi All,
I have a problem with a Form that has 2 fields which I want to remove and 1 field which I want to add.

I want to remove the 2 fields because I have setup 2 new tables using these field names because they both have quite a lot of data in them and I want to to use them in a list box in the Form.

The field I want to add to the Form is an address field (District) which I overlooked when setting up the relavent table.

The problem I have is that the Form is linked and Access refuses to let me MODIFY the Form. I have removed the relationships and even tried to modify the table by removing the ID fields in the linked tables. None of this works.

I would be very happy if anybody could help with this?

Thanks
Gerry

 

[Travis]

You will need to modify the tables from the database that they reside in.