Create a form that has a fixed number of fields.

[Guest]

Hello I am trying to create a DB to inventory the DS3's that we have here in
our office. Each DS3 has 28 specific channels that are used independantly. So
what I am trying to accomplish is create a form that will allow me to enter
this data. How do I create this?

Example of what I am trying to accomplish:

DS3 NAME:
Channel 1: Information
Channel 2: Information
etc, until 28.

My problem is that I need to see all channels even when vacant and I need
all 28 that are related to each DS3.

Thanks, sorry if this is confusing

 

[Guest]

Hello Shammy,

I have no idea what a "DS3" is, but I think I can provide a general outline
of how to attack this problem. You will want to store the channel information
in a separate table, which is related to a parent table that includes the
main information for each DS3. This information will be displayed using a
form / subform arrangement. The subform will display the channel information
for each DS3.

In the Form_AfterInsert event procedure for the main form, you can run an
append query to add new records to the related table:

Private Sub Form_AfterInsert()
Your code goes here to append (add) 28 new records
End Sub

Without knowing more details about your database (names of fields & tables,
etc.) it's a little hard to provide specific help.

If my answer has helped you, please answer yes to the question that reads
"Did this post answer the question?" at the bottom of the message thread.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Hello I am trying to create a DB to inventory the DS3's that we have here in
our office. Each DS3 has 28 specific channels that are used independantly. So
what I am trying to accomplish is create a form that will allow me to enter
this data. How do I create this?

Example of what I am trying to accomplish:

DS3 NAME:
Channel 1: Information
Channel 2: Information
etc, until 28.

My problem is that I need to see all channels even when vacant and I need
all 28 that are related to each DS3.

Thanks, sorry if this is confusing