Data entry for a table from a form

  • Thread starter Thread starter Haas C
  • Start date Start date
H

Haas C

Hi all!

I'm a newbie when it comes to programming VBA and I need some help here. For the sake of simplicity, I am giving an example for just two fields so I can learn the programming technique to capture data entered into a form to be added to a table:

I have a table called tblContacts
There are two fields in this table: CompanyName and PhoneNumber

I created a form where the user can see if a company name exists through a Combo Box with the source being the list of entries in the tblContacts field - if it doesn't, he enters a new company into the a txtCompanyName box and a phone number into the txtPhoneNumber box on the form. Next, user presses a button on the form which would call a VBA procedure which runs and takes the values from txtCompanyName and txtPhoneNumber and adds to the tblContacts table

I know that you can do this easily through Form Wizard, but I wanted to know how to program this into a VBA procedure. This is a simple example to learn the technique so I cna apply it to one with multiple fields, etc.

Thank you for your help in advance!
 
See my answer in the microsoft.public.access.forms newsgroup. It's usually
not necessary to ask the same question in multiple closely-related
newsgroups... if you do, it's best to use cross-posting so the answer will
show up in both (or all) newsgroups; individual posts of identical questions
may lead to someone wasting effort answering a question that's already been
answered.

--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010

Hi all!

I'm a newbie when it comes to programming VBA and I need some help here. For
the sake of simplicity, I am giving an example for just two fields so I can
learn the programming technique to capture data entered into a form to be
added to a table:

I have a table called tblContacts
There are two fields in this table: CompanyName and PhoneNumber

I created a form where the user can see if a company name exists through a
Combo Box with the source being the list of entries in the tblContacts
field - if it doesn't, he enters a new company into the a txtCompanyName box
and a phone number into the txtPhoneNumber box on the form. Next, user
presses a button on the form which would call a VBA procedure which runs and
takes the values from txtCompanyName and txtPhoneNumber and adds to the
tblContacts table

I know that you can do this easily through Form Wizard, but I wanted to know
how to program this into a VBA procedure. This is a simple example to learn
the technique so I cna apply it to one with multiple fields, etc.

Thank you for your help in advance!
 
Back
Top