We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

add fields from form into a table

davetough
davetough asked
on
Medium Priority
217 Views
Last Modified: 2012-06-27
I have had help with this form - entering the serial number in textbox -hit enter and having it fill a listbox- then finally adding numbers from listbox with command button into table.

Now problem is I have -is having other fields ( shipDate,Run,chk1,chk2,chk3,chk4, CVSKey be added into table -with the serial number. and is it possible?
thank you
database.mdb
Comment
Watch Question

Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
The simplest way is to base the form on your table, then add controls to your form that are based on the various table fields. If you "bind" them, Access will manage the data work for you.

Commented:
Easiest if those additional fields are already in the table. Can you explain why they are not?
Solutions Architect
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Hamed NasrRetired IT Professional
CERTIFIED EXPERT

Commented:
Tried the attached database in the solution. It did not work!. It gives can't save error.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.