how to input multiple records with the same information

[Guest]

Any ideas on how to input records that have some of the same information
without inputing everything on each record. Like apartment addresses that
share the same street address, city, state, zip but different apartment
numbers and tenants. I want to enter seperate records for each apartment and
tenant without having to type the other information 300 times. I've tried
using sub forms, but I cant get the main info to attach to the seperate
apartment records or vice versa. I'm working with one big table instead of
many smaller tables if that makes a difference.

 

[Todd Shillam]

Any ideas on how to input records that have some of the same information
without inputing everything on each record. Like apartment addresses that
share the same street address, city, state, zip but different apartment
numbers and tenants. I want to enter seperate records for each apartment
and
tenant without having to type the other information 300 times. I've tried
using sub forms, but I cant get the main info to attach to the seperate
apartment records or vice versa. I'm working with one big table instead
of
many smaller tables if that makes a difference.

Sean,

You should really normalize the database by breaking up the table into
smaller related tables. However, you can default values in the form with a
little VBA coding. For example, you could add a button the form and when you
click the button it can insert default values into the form fields, but you
would have to code that functionality. The following example illustrates the
idea, but its a little rough:

Private Sub Command0_Click()

'DECLARE VARIABLES
Dim Block01 As String
Dim Block02 As String

'INITIALIZE VARIABLE VALUES
Block01 = "555 5th Street"
Block02 = "CityName"

'SET FORM FIELD VALUES
Forms![frmName]![txtFieldName].Text = Block01
Forms![frmName]![txtFieldName].Text = Block02

End Sub


Best regards,

Todd

 

[Michael J. Strickland]

Sounds like that would be easier to do in Excel if you have it.

Enter the apartment street address, then copy rows down and then add
apartment numbers.