Possible Linked Table Problem 1

[jdspinelli]

Good Morning:

Can anyone point me in the right direction? I have a linked table that had two columns (both booleans) that I no longer needed. I deleted the columns from the table and, upon opening a form that used that table, Access asked me for a parameter in the format <tableName>.<columnName>. I searched my code for a reference to that deleted column name and it was nowhere to be found. I finally added back the deleted columns and the code works. HOWEVER, I want to delete those unwanted columns at some point.

Here is my question: is there a way to programmatically search for the deleted field names in properties - since I did not find it in the code? Can anyone suggest how I might find this orphaned reference?

Thanks in advance,
Joe

 

[vise]

Hi,
Try looking at the properties of the form in design mode. Then go under the "Data" tab and look at Record Source.

This might be where the errant fields are referenced. Just remove them from the select statement if they are there.

Otherwise, you might have a field on the form that is trying to get that data. You should delete that field.

 

[jdspinelli]

Thanks much vise,

My form was intended to be Unbound. I assigned a query as a recordSource early on and never removed it.

This has been very helpful,
Joe