Deleting fields

[c-bert]

Hi all,

I've just been trying to delete fields from a legacy database (not one I created). No problems there however, now whenever I open a related form (not containing aforementioned fields) it asks me to locate them. How do I break the link to these old fields?

I've tried searching the form's code but I can't find any reference to them. Help!

 

[MattS]

Is the form bound to a query that's based on the table in question? If so, the fields might be part of the query. Or, there could be a control on the form, such as a list box or combo box, which is bound to the table/query.

 

[TessB]

Don't know a thing about legacy databases or any sort. But, could it be possible that the form is based on a query that references the deleted fields?

 

[c-bert]

OK guys, that sounds more than feasible. Now Access for benginners time! How can I track down which one(s) (of a lot) of queries the form in question is linked to and when I've done that, can I just remove the offending fields from said query?

Many thanks...

 

[c-bert]

It's OK, I think I've sorted it. I just deleted the querys one at a time (having backed up!) until I found the right one.

 

[TessB]

Open the form in design mode. Click on the little square in the left corner where your rulers meet. Click on properties. (that's the icon with the hand pointing to a piece of paper...) In the properties box, you will see 5 tabs. Click on the one that says data. The first line on that tab is the Record Source. That is where the form gets it's data. It could be a table, a saved query, or a query built in the form. Click on the ellipsis to see if it is just a query built especially for that form. If it is, the query will come up and you can modify it. If it isn't, it will say that you invoked the query builder. (Answer NO if you get this and just note the name of the query or table you are looking for.

Hope that helps.

 

[c-bert]

Thanks Tess, that's a much better (and less destructive) way of doing it. Thanks again,

Mark