Forms Question

[cbende2]

I have two forms that are pulling info from one of my tables.

In the forms I originally had the field [PlanName] and it was pulling the plan name form the table. Once I worked in relationships into my database, I changed plan name to PlanNameID and deleted the feilds on the forms. However, when i open the forms, it asks for parameter value of "table.PlanName"

How do I get this parameter to go away?



When this happened to me before, I just recreated the form and the error was gone. There has to be an easier way... I did try decompiling and compiling my database in hopes of getting rid of the non-existant field, yet it still remains in the "add existing fields" for the table I'm using.

Thank you all!

[lynnmc26]

When you create your form, are you using a query? That way the form will look to just the items in your query and that parameter will go away.

[cbende2]

yes I'm using a query, but I already checked all of that, I removed the field [PlanName] from everywhere...except for the parent table which assigned [PlanName] the unique ID.

[June7]

If you want to provide db for analysis, follow instructions at bottom of my post.