Opening form runs parameter query?

  • Thread starter Pamela via AccessMonster.com
  • Start date
P

Pamela via AccessMonster.com

Here's my problem:

I have a form with a subform which WAS related by a common field (PIN). I
deleted the relationship between the master/detail form & deleted the field
entirely (& the bound control on the subform) from the table the subform is
based on.

Now when I open the main form, it prompts me for the field I deleted from the
subform's table!

If I enter a value in the parameter prompt, the subform will open (but does
not work), if I don't enter a parameter, the subform doesn't show up at all.

I don't understand - nowhere in my project is there a reference to "GrpPIN"
(the field I deleted), & it's not referenced in any queries either?

Ideas?
 
W

Wayne Morgan

A reference to that field still exists somewhere. Some places to look:

1) The Master/Child links between the main form and subform. This item is
available in the Properties of the subform control on the main form. They
are located on the Data tab of the Properties dialog.

2) Check the WHERE clause of the query that feeds the subform.

3) Check for any calculated fields in the query feeding the subform to see
if any of the calculations refer to the deleted field.

4) Check for calculated controls on the main form or subform whose Control
Source may refer to the deleted field.

5) Check the Filter and Order By properties of the subform (in design view)
to see if they mention the deleted field.
 
W

Wayne Morgan

Another place to look:

6) Check the Row Source of any combo box or list box to see if they refer to
the deleted field.
 
P

Pamela via AccessMonster.com

It was number 1...I had only looked on the Master form properties for the
child/master link. I knew it had to be someplace. Thanks! Now to get the
subform to behave like the otehrs. I have re-established a relationship
between the subform & main form (this time using the Main form's record ID-
ID is PK, RecID is FK). Everything seems like the other subforms, but any
changes I make in the subform aren't being properly displayed...only one
record is shown...if I can get this part fixed I'll be a happy camper.

Thanks!
 
W

Wayne Morgan

Is the subform set for Data Entry? If so, it will only show the records
you've entered that session. Do you have any filters on the subform or main
form? What format is the subform set to show as, single form, continuous
form, or data sheet? Have you looked at the subform's table to see if there
is more than one instance of the FK (RecID) in that table?
 
Top