ADDING MORE RECORDS DEPENDING ON AMOUNT

[Bobby Chun]

Hello,

Is there a way to add more records to a form that depends on the amount?

For example, on one form the client may have 3 records while the next client
may have 15? Do I have to create a table that lists 15 open fields or can
there be a way to add more records as needed?

I'm not sure how clear I am but it is kind of hard to explain.

Any help would be much appreciated.

 

[tedmi]

You do that with a subform in datasheet or multiple form view. When properly
linked, the subform will hold however many records the current client has,
and allow the user to scroll through them.

 

[John W. Vinson]

On Tue, 30 Sep 2008 06:01:01 -0700, Bobby Chun <Bobby

Hello,

Is there a way to add more records to a form that depends on the amount?

For example, on one form the client may have 3 records while the next client
may have 15? Do I have to create a table that lists 15 open fields or can
there be a way to add more records as needed?

I'm not sure how clear I am but it is kind of hard to explain.

Any help would be much appreciated.

You need TWO TABLES in a one to many relationship: one for Clients (in which
each client will have one record), and a second table for what you're calling
"records". This second table would have a ClientID, a link to the primary key
of the clients table; you could use a Form based on the clients table with a
Subform based on the "records" table to enter data.

Take a look at some of the tutorials on how Access works:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials