Showing multiple records on a form

[farooqkhan123]

Hi
I have a table with several fields, the following are relevant for example.
Serial - Name - Quote Number - Policy Number - Date - Rate

Only Serial is a Primary Key and Unique.
Name of this table is "CONSOLIDATED".

I also have a form that opens up specific records showing various fields from this table. Form name is "PUN Prefill".

One set of fields in the form is Rate.
I want to be able to show in front of this field RATE on the form a box that contains RATE field from all the records in the table where POLICY Number or Quote Number is matching.

So my form will show RATE from current record, and all other records where POLICY Number or Quote Number matches and displays along with its respective Date.

Any ideas how this can be displayed on my form as view-only?

Thanks.

[NeoPa]

I would suggest a linked sub-form which you can set as read-only.

[farooqkhan123]

How?? Am newbee in access

[NeoPa]

How what? What can you do and what can you not?

I don't see it as my task to spoonfeed you simply to save you the responsibility of writing what you need to to work with somebody else.

I'm sure you're new, but that doesn't mean you're incapable of expressing your situation properly.

[farooqkhan123]

how meant how to create a subform and how to make it show the rate fields from another record in the table that matches the fields of current form in Policy Number OR Quote Number.

hope it explains better now

[NeoPa]

First make a main form (frmA). Then make a separate form for the related details (frmB).

Go back to frmA and add a Sub-Form control. The wizard will pop up and prompt you for the form to use (frmB) and which fields of frmA should match those of frmB.

This is fairly basic stuff, so youy may benefit from spending some time getting to grips with some of the basics at Microsoft Access Tutorials (Strive4Peace).