Unncessary field names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have created a few forms, but then i realised that the tables they are
based on dont need certain fields. if i delete the fields from the table, i
get a parameter window when i open the form- which would ask me for values of
the deleted fields.
So what i did was keep the unwanted fields in table so that i wouldnt get
the windows popping up every time i want to open the form i created earlier.
However, that means my tables are quite messy and i dont really want to redo
the forms again.
does anyone know of a way to get rid of those popup windows in the first
place without having to keep those unwanted fields in the table.?
thanks
 
Either you forgot to remove the text boxes bound to those fields from your
form, or you're using a query that still has the field names in it.
 
The field names are only on the field list of the form but not on the actual
form itself
 
If the field names are still showing in the field list, then take a look at
the form's RecordSource.

If you created the form using a wizard, Access will have created a query
based on whatever you told it to take from the original table, and you'll
need to get rid of the fields from that query. (Click on the ellipses, or
three dots, to the right of the RecordSource property if you can't see it
well enough)
 
Thanks
It works now :)
Connie


Douglas J. Steele said:
If the field names are still showing in the field list, then take a look at
the form's RecordSource.

If you created the form using a wizard, Access will have created a query
based on whatever you told it to take from the original table, and you'll
need to get rid of the fields from that query. (Click on the ellipses, or
three dots, to the right of the RecordSource property if you can't see it
well enough)
Click to expand...
 
Back
Top