I have a form which has certain hidden fields that auto-populate upon composition, using the values from the last saved document of the form. I use the same form on multiple databases, however I only run into this problem on a few databases, and only on a few of the fields. It does not pose that much of a problem, however I am curious as to why this is happening. Anyone have any ideas? Much appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Fields auto-populated with value from last document 1
- Thread starter 1uptheman
- Start date
-
1
- #2
- Thread starter
- #3
Several things to check then :
1) Do the fields that are populating have a formula ? If so, is the formula correct ? Do you want to change it ?
2) Is Field Inherit activated ? Check that in the Form properties, 2nd tab on the left (beanie tab). If "Formulas inherit values from selected document" is checked, uncheck it.
3) You also need to check the QueryOpen and PostOpen events for any code that could retrieve stuff automatically. Your call if you want to modify any of it.
4) Finally, you need to check the fields themselves, to make sure that none of them loads info automatically from the database.
Last, but far from least, you need to think about what you are breaking by doing this, will you have to repair said damage and does it matter.
It is best to be careful
1) Do the fields that are populating have a formula ? If so, is the formula correct ? Do you want to change it ?
2) Is Field Inherit activated ? Check that in the Form properties, 2nd tab on the left (beanie tab). If "Formulas inherit values from selected document" is checked, uncheck it.
3) You also need to check the QueryOpen and PostOpen events for any code that could retrieve stuff automatically. Your call if you want to modify any of it.
4) Finally, you need to check the fields themselves, to make sure that none of them loads info automatically from the database.
Last, but far from least, you need to think about what you are breaking by doing this, will you have to repair said damage and does it matter.
It is best to be careful
- Thread starter
- #5
Thanks, I appreciate your input. I checked all of the things you mentioned, however none seemed to work. They were computed fields with their value set to themselves. There was no real need to have them be computed, so I ended up changing them to editable, and that solved my problem. Thanks for your help though!
Computed fields with values set to themselves - is exactly what is needed to inherit.
I take it that, in addition to making the fields editable, you also removed the formula - that is most probably what solved your problem.
Just for your information, when a form is set to inherit values, on creation of the new document (and only then), all formulas in all fields refer to the document that is selected/highlighted at time of creation. So your computed formulas were working as inteded, and removal of the formulas removed the issue.
Pascal.
I take it that, in addition to making the fields editable, you also removed the formula - that is most probably what solved your problem.
Just for your information, when a form is set to inherit values, on creation of the new document (and only then), all formulas in all fields refer to the document that is selected/highlighted at time of creation. So your computed formulas were working as inteded, and removal of the formulas removed the issue.
Pascal.
- Status
Similar threads
- Locked
- Question