Nested one to many forms

I'm trying to put toghether a data entry form that uses nested one to many form/subforms.
 
The structure is Each location has many dates and each location/date has many parameters and values.

The outermost form would simply consist of location.  Inside this would be a date subform and inside of this would be the list of parameters entry fields.

The idea is that you would select location then select date and then the data for that location/date would appear for entry or editing.  

I've got something close to what I want.  It works if all the data is entered at once, however, if data is entered at different times it doesn't save for that location/date it creates another record for that location/date.

I'm not sure if I'm explaining this very well.

Any ideas?
tmortAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

baskomurcuCommented:
First of all which version of Access are you using? I tried a form the way you described and couldn't find any problem. Can you send me a copy of the form to Ali.Baskomurcu@datem.com.tr and describe your program with an example.
0
wrussell051197Commented:
Hmm, not sure if I completely understand your problem... The data has to be entered from the outermost form inward, otherwise there will not be a record created. You can get around this by putting an autonumber field in the tables bound to the outer two forms and using those as your Master, child fields. Let me know if that helps...
0
danielmarkusCommented:
It sounds verry complicated. I think I can help you if you explain something about the relation between the location table and the location/date and the date table or any other tables that might be involved.

Perhaps you can also send a copy of the form and the tables and queries that are involved



0
ProgPlusCommented:
There are two parts to the answer:
1) Access accommodates a maximum of 3 levels of subform depth.
2) You don't have to use a subform to have one field limit the contents of another.  From your description, it sounds like your Date field doesn't need a subform of its own--it can be on the same form as your initial Location field.  To limit the Date field, base it on a query that looks at the Location field as one of its parameters.  To make the Date field update, add an AfterUpdate event to the Location field, and in it put a line like this:

Me!DateFieldName.requery
Me!DateFieldName.setfocus

Hope this helps.

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.