• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • Last Modified:

Access design question form or subform

I have a data entry form with list boxes for client, IA, Mail Reason and mail pcs processed.  The user selects one entry from each list then enters the number of mail pcs processed and saves to the database.  

I need to allow this user to add new IA's to the database.  The IA data consists of 4 columns of information required for entry.  What is the best way to do this?
Create a subform on this form?  
Create a different form?
Ruled out combo because of the 4 columns of data required.

  • 2
  • 2
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You'd be better off building a separate form for this. Just base the form on the table hosting your Client "IA" information. When the user needs to add a new Client "IA" Record, you could use this code:

DoCmd.OpenForm "YourNewForm", , , , acFormAdd

This would open that form in Data Entry mode, where the user could add a new record.

You'd probaby need to requery the combo or listbox on the other form after doing this:

rhadashAuthor Commented:
Ok I think I can do that but one more question.  I will not want to show the IA_ID which is primary key in the new IA entry form.  Is there specific code to update as records are added?
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I'm not sure what you mean.

If IA_ID is an AutoNumber field, then Access will manage that regardless of whether the field is on the form.

If IA_ID is NOT an AutoNumber field, then you'll have to manage that yourself.
rhadashAuthor Commented:
Thanks.  That's what I needed to know.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now