By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,436 Members | 2,979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,436 IT Pros & Developers. It's quick & easy.

Showing multiple records on a form

P: 8
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.
Feb 17 '16 #1
Share this Question
Share on Google+
5 Replies


NeoPa
Expert Mod 15k+
P: 31,494
I would suggest a linked sub-form which you can set as read-only.
Feb 18 '16 #2

P: 8
How?? Am newbee in access
Feb 18 '16 #3

NeoPa
Expert Mod 15k+
P: 31,494
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.
Feb 19 '16 #4

P: 8
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
Feb 19 '16 #5

NeoPa
Expert Mod 15k+
P: 31,494
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).
Feb 22 '16 #6

Post your reply

Sign in to post your reply or Sign up for a free account.