Error in Combo Filter

[Ste4en]

Pleae take a look at the attached database, open frmUpdate and select an item in Group1.
I get a message box "Enter parameter Value" - Group1.

After I click OK, sometimes I get a run-time error, usually everything works fine until the form is reopened.

Can anyone see my problem.



thanks
Steve

 

[gromit]

Hi Steve -

Not sure that I have a good handle on this, but I'll throw my two cents in.

The error message is occurring when you try to update the Master field on the main form. Part of the issue, I believe, is that the main form doesn't have an associated recordsource, so the field [Group1] does not have anything to refer to.

Try this: go to the main form properties and set the record source to tblData. I believe this eliminates the problem.

I have had problems with cascading combo boxes and parent/child relationships. I have to say that I don't really fully understand why. My usual solution is to eliminate the Master/Child relationships and just drive the form and subform record source with SQL.

Maybe someone else on the forum can illuminate us both.

hth,

- g

 

[Ste4en]

Gromit, Thanks for the help. That solved my problem.
steve

 

[gromit]

Great - glad that it worked!