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.

Thanks,
rhadashAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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:

Me.YourClientListbox.Requery
0
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?
Thks.  
0
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rhadashAuthor Commented:
Thanks.  That's what I needed to know.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.