Re: queried data block on form
Date: Sun, 12 Sep 1999 21:03:38 GMT
Message-ID: <KyUC3.218$tS.11715_at_nntp.csufresno.edu>
In article <37D975E9.D619FF7B_at_creditwatch-inc.com>,
Brian Howard <bh_at_creditwatch-inc.com> wrote:
>I have a form which has a page from an 'accounts' table. I have designed
>the datablock on the table to be in form format which looks at one
>record at a time; however what I would like is to have an area below it
>which shows all the records pulled from the query in tabular format.
>Then if a user clicks on a record in the bottom tabular part, it
>switches to that record in the form section above. This seems basic but
>I am having difficulty getting it to work. Do I make a second datablock
>based on the same table? How do I do this? Please explain.
Use one block. Set your block's Records Displayed property to (perhaps) 10. For the items that you want to display in form style, set their Items Displayed property to 1. For the key items used to select which record you want, set their Items Displayed property to 0, and they will use the Records Displayed property from the block.
I usually set the column of selection items on the left side of the screen along with a scroll bar, and the single (form-style) items on the right. If you need to have an item both in the selection column as well as the form-style area, try two items, and use the Mirror Item property (unfortunately, the two items keep same display characteristics, so I haven't used the Mirror feature).
Steve Cosner
http://members.aol.com/stevec5088
Downloadable Quick Access utility form: Display and update any table. Received on Sun Sep 12 1999 - 23:03:38 CEST