Parameter Value Problems

[timwagg]

Hi,

I have been designing a database for my Dad's work and I'm trying to have a subform in one of my other forms to display events registered.

Basically the database has

Events
Registration
Attendees
Flights

On Events I have a subform which shows all the people registered to that event but on the Attendee subform, it should, and used to have all the events that attendee is registered too. I also register people on flights and I have a depended combo box for this i.e. select date of flight and then next combo box display all the flights for that date.

The only problem is everytime I save and close the reg form the subform no longer fills and I get the Enter Parameter Box popping up asking for 4 different values.

I have searched for this and found one or two answers but I still don't know how to apply the solutions to my database. Does anyone have any ideas?

Many Thanks.

Tim

 

[boblarson]

Can you post your db?

See here for how - http://www.access-programmers.co.uk/forums/showthread.php?t=140587

 

[timwagg]

Here it is...hope this helps, I'm going mental over here trying to get this sorted!

Tim

 

[trab]

A long time after the event, but I wonder if this ever got sorted. It would have been useful to know.

I have a form with three subforms, and when I close the main form, I get a succession of 5 parameter value requests, all seemingly relating to 2 controls on the main form. The 2 controls are linked in some shape or fashion to the subforms.