Enter parameter value

[Access_Help]

I have a form with two combo boxes

I have a command button assigned to a MACRO which will open a report based on the values entered in the combos.

Everything was working fine until I closed the database and re-opened it and now it says Enter Parameter Value followed by: Forms!frm_Name!Combo21

When I type the same values as the combos into the prompts the report displays as expected but will just not work by selecting the values from the list


I have checked the names of the combos and nothing has changed!

I don't know what has gone wrong!

 

[arnelgp]

Chk the forms recordsource.

 

[Access_Help]

Chk the forms recordsource.

It was an unbound form (but I added a record source to it now) and it works!

I didn't think it needed a record source as the form is being used as a menu?

 

[arnelgp]

If it is unbound chk the data tab of property and remove any values there.
Also chk the Load / open event of the form

 

[Access_Help]

OK, so that worked temporarily, but now when I closed and re-opened it and I was prompted again by the same Input Parameter value error.

This is what I have in the Open Report Macr which is assigned to a command button on the form named Form1.

[Forms]![Form1]![Combo0]=[qry_Loans]![Class]

What do I need to look for in the Load and Open Event?

 

[arnelgp]

You can assign it through the Forms load event and not through macro:

Private sub form_load()
Me.combo0=dlookup("class", "qry_loans") & ""
End sub