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

MS Access: Form does not submitt data to table

James Coats
James Coats asked
on
Medium Priority
234 Views
Last Modified: 2012-05-11
The form called “NewToolDataEntry” is not submitting the data from fields “Tool Name”, “Type of Device” and “Location”.

I don’t really understand why.

Measuring-Instruments-3-4-22-11.mdb
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016

Commented:
your combo boxes “Tool Name”, “Type of Device” and “Location” and Brand are all Unbound.

set the Control Source of the combo boxes respectively to the table fields.
LucasMS Dynamics Developer
CERTIFIED EXPERT

Commented:
that's because your combo boxes are not bound to any field in the database.

If you open the form in design view, it will show unbound.

To store data, you have to have them bound to a field in your table.
CERTIFIED EXPERT
Top Expert 2016
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
James CoatsComputer Info. Sys. Student

Author

Commented:
Thanks Capricorn1,

I am new to Access and don't like it much but I do like learning more as I need to know this. Sorry about taking so long to answer (I saw your quick response) but my computer crashes all the time and is likely a covert Apple II C. I am supposed to get a new one soon.
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.