Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • Last Modified:

MS Access: Form does not submitt data to table

The form called “NewToolDataEntry” is not submitting the data from fields “Tool Name”, “Type of Device” and “Location”.

I don’t really understand why.

James Coats
James Coats
  • 2
1 Solution
Rey Obrero (Capricorn1)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 DeveloperCommented:
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.
Rey Obrero (Capricorn1)Commented:
James CoatsComputer Info. Sys. StudentAuthor 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.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now