Enter Parameter Value Error On Form With Only Subforms

[EnginerdUNH]

Hi,

I am working on building an administrative controls form for the database that I've been building. The form itself has no record source and is just an empty form consisting of four subforms. The issue that I've been running into is that when I go to open the form, Access gives me an "Enter Parameter Value" error that only started occurring when I added the two most recent subforms. I do not get the error when I go to load the subform separately from the main form. Any ideas on what could be causing this?

[EileenStifone]

You must check in the queries set as Record Source of the offending subforms that there is no reference to a control, which acts as a filter, but cannot be found in any of the open forms.

[Gasman]

And what parameter value is it asking for?
That would be a clue?

Subforms load before mainforms.

[EnginerdUNH]

Hi EileenStifone, I did confirm that the queries for the record sources on the offending subforms are only referencing fields on that form. Also, if that was the issue, wouldn't I also be having this issue when trying to load the subforms on their own, separate from the main form? As stated in the OP, doing that works fine, it's just when I try to load them as a subform.

Hi Gasman, on both of the subforms, it's the fields it's asking for parameter for are an autonumber and a number. Also, I did read something somewhere I think about subforms loading before the main form. Do you know if there's a way to delay loading of the subform to see if that resolves my issue?

[Gasman]

You can set the subform control sourceobject in the main form load?

Alternatively, upload the db with instructions on how to recreate.

[EnginerdUNH]

You can set the subform control sourceobject in the main form load?

Alternatively, upload the db with instructions on how to recreate.

Ok I've tried the following with no success:
1. Removing the source object from the subform properties in design view and setting it on the on load event of the main form
2. Opening the subform to a new record on the on load event of the subform

Neither step, separate or together, worked to resolve the issue

[EileenStifone]

If you can post the file.

[HansV]

Let's say the name of the subform in the navigation pane is MySubForm.
Do you refer to Forms!MySubForm!... in the record source of the form, or in the control source or row source of any of the controls on MySubForm?
That will work if you open MySubForm by itself, but not when you open the main form that contains MySubForm, because in that situation MySubForm is not part of the Forms collection. You'd have to use Forms!MainFormName!MySubForm!...

[EnginerdUNH]

Let's say the name of the subform in the navigation pane is MySubForm.
Do you refer to Forms!MySubForm!... in the record source of the form, or in the control source or row source of any of the controls on MySubForm?
That will work if you open MySubForm by itself, but not when you open the main form that contains MySubForm, because in that situation MySubForm is not part of the Forms collection. You'd have to use Forms!MainFormName!MySubForm!...

Hi Hans, I went into the query behind the record source and sure enough there was a Forms!MySubForm!... reference in both of the offending queries. I changed the references to Forms!MainFormName!MySubForm!... and now they work! Thanks so much!! Definitely not something I would have thought about.

[Gasman]

Now they will not work if you open the subform on its own.

I used to use tempvars if I needed the form in both modes for any reason.