We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Nested one to many forms

tmort
tmort asked
on
Medium Priority
366 Views
Last Modified: 2008-03-03
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?
Comment
Watch Question

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.
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...
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



Commented:
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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.