Data entry for a table from a form

[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!

 

[Access Developer]

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!