truoble with deleted fields

  • Thread starter Thread starter Amin
  • Start date Start date
A

Amin

Hi i have downloaded the contacts template from office online and deleted
some field i din't wanton the database and this is causing me a great deal.
my forms now behave unusal. anytime i try to open a form a dialog box pops up
and on it is the name of the field i deleted. what do i do now cause i need
the table arrange to my liken.
 
Amin said:
Hi i have downloaded the contacts template from office online and deleted
some field i din't wanton the database and this is causing me a great
deal.
my forms now behave unusal. anytime i try to open a form a dialog box pops
up
and on it is the name of the field i deleted. what do i do now cause i
need
the table arrange to my liken.
Click to expand...

Check the form's recordsource to see if the field is in a query, and delete
it from the query. Also check the controls in the form to see if one is
still bound to the field. Both situations would cause your problem.
 
hi Arvin i have checked the record source and is query but in the design the
field is no longer there, however i had to manually delete the field from the
form. when i double click the query a pop up box with the filed i delete
comes up. i need to click ok to open it or i just cancel it
 
Hi Arvin still on that issue i have sorted it now. i have ope the query in
design view and open the the expression builder for the other two headings
where the deleted field was included in the builder and deleted it from them
and now is working properly thank you.
 
Back
Top