I have a table in access 2000 with key field "form ID" in it, and some other fields too...
When i make a query or a report using fields Form ID and anything else from this table, when saved and closed, and then consequently run, it will change the other fields in the query/report into Form ID too (ie if i select 'form id' and say 'form title' it will change form title to form id too, and it gets displayed as Expr1000 coz it cant use teh same name coz 'Form id' already exists from the original) and displays the form id contents,
and in deisgn view, what was a differnt field is sure enought form id, so it chanegs everything u put in the query from that table to form id. bizaree.
and its really annoying
please help!!
cheers
When i make a query or a report using fields Form ID and anything else from this table, when saved and closed, and then consequently run, it will change the other fields in the query/report into Form ID too (ie if i select 'form id' and say 'form title' it will change form title to form id too, and it gets displayed as Expr1000 coz it cant use teh same name coz 'Form id' already exists from the original) and displays the form id contents,
and in deisgn view, what was a differnt field is sure enought form id, so it chanegs everything u put in the query from that table to form id. bizaree.
and its really annoying
please help!!
cheers
