R5 - In a view, creating a feature to open a list of forms
R5 - In a view, creating a feature to open a list of forms
(OP)
I asked a similar question a while ago, but I think I know now exactly what I'm looking for. Using an action button, create some type of pompt for the user to select the document that will display the data they currently are viewing. Right now, I have it set up to choose one or another based on how I imported the data.
So, the user clicks the button and a list of forms/docs comes up: frm1, frm2, frm3, etc. Then the user chooses one, clicks ok, and the data they had selected in the view populates the specific document.
Is this possible? Or is there an easier way to get at this?
Thank you
So, the user clicks the button and a list of forms/docs comes up: frm1, frm2, frm3, etc. Then the user chooses one, clicks ok, and the data they had selected in the view populates the specific document.
Is this possible? Or is there an easier way to get at this?
Thank you
RE: R5 - In a view, creating a feature to open a list of forms
In other words, are you thinking of creating a function that gathers all forms of a certain name format and displaying that ?
In which case I would say it is impossible.
Otherwise, I do not understand why our previous solution does not interest you. Have you tried and did it work ?
Pascal.
RE: R5 - In a view, creating a feature to open a list of forms
It's like having 3 fields that are exactly the same on 3 different forms/docs. But depending on what else is needed to finish a document, determines what form to choose from the list under the New Document button.
I have a feeling this may not be possible, but I'm just checking. I appreciate all the help.
RE: R5 - In a view, creating a feature to open a list of forms
If you have anything more complicated than single-document inheritance on creation, then you need to script it in the PostOpen event.
On the other hand, inheriting information depends entirely on the form you use, so you could use the suggestion I have already given, create three different forms and have each one inherit differently from the selected document.
But if you need multiple-document inheritance, then we are no longer talking inheritance but PostOpen script and @dblookup functions in header fields and other such info-gathering means.
Pascal.
RE: R5 - In a view, creating a feature to open a list of forms
For a better idea of my database, I have a 3 stage database. It begins with basic data entry (names, dates, corresponding information). Then another user will be prompted and they will finish out the other pieces based on that data. The third step depends on the completion and accuracy of the first 2 before a report can be printed.
RE: R5 - In a view, creating a feature to open a list of forms
The difficulty lies not in the retrieval of information, but in what you do with it afterwards. A @DbColumn retrieves multiple values, which you then have to manage and eventually break down according to what your needs are. That can prove tricky, especially if you recover info from multiple sources.
Pascal.