Display multiple records on a single form

[Melissa]

Hello,

I have an access/vba application I'm trying to extend. I'd like to create a
new form in which several records are displayed, followed by an edit and
delete button. A textual representation of what I'd like is as follows:

Person ID - 123456
Order ID - Product ID - Quantity
ord123 - prod123 - 4 [EDIT BUTTON] [DELETE BUTTON]
ord234 - prod234 - 3 [EDIT BUTTON] [DELETE BUTTON]
ord345 - prod345 - 5 [EDIT BUTTON] [DELETE BUTTON]
....

The number of records will be dynamic because each individual will
potentially have any number of records which I'd like to display on a single
page. Can anyone provide me with some tips as to the best way to implement
this type of form and possibly some sample code (or a URL to some sample
code)? I'm relatively new to access development, so I'm not even sure what
controls I'd need to use to facilitate this functionality, so any advice
would really be appreciated. Alternatively, if someone has another
suggestion regarding how I can go about implementing this functionality I'm
all ears.

Thanks a lot,

Melissa

 

[Rick B]

Melissa:

Please stick to one post.

http://www.mvps.org/access/netiquette.htm

 

[Rick Brandt]

Hello,

I have an access/vba application I'm trying to extend. I'd like to
create a new form in which several records are displayed, followed by
an edit and delete button. A textual representation of what I'd like
is as follows:

Person ID - 123456
Order ID - Product ID - Quantity
ord123 - prod123 - 4 [EDIT BUTTON] [DELETE BUTTON]
ord234 - prod234 - 3 [EDIT BUTTON] [DELETE BUTTON]
ord345 - prod345 - 5 [EDIT BUTTON] [DELETE BUTTON]
...

The number of records will be dynamic because each individual will
potentially have any number of records which I'd like to display on a
single page. Can anyone provide me with some tips as to the best way
to implement this type of form and possibly some sample code (or a
URL to some sample code)? I'm relatively new to access development,
so I'm not even sure what controls I'd need to use to facilitate this
functionality, so any advice would really be appreciated.
Alternatively, if someone has another suggestion regarding how I can
go about implementing this functionality I'm all ears.

Thanks a lot,

Melissa

A standard Access form can be displayed in three different "views". These are
single record, continuous, and datasheet. Continuous view will give you what
you want.