?
Solved

Nested one to many forms

Posted on 1997-08-09
4
Medium Priority
?
324 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?
0
Comment
Question by:tmort
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 

Expert Comment

by:baskomurcu
ID: 1955550
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
 

Expert Comment

by:wrussell051197
ID: 1955551
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
 
LVL 1

Expert Comment

by:danielmarkus
ID: 1955552
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
 

Accepted Solution

by:
ProgPlus earned 200 total points
ID: 1955553
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question