Form w/ Combo and unbound text, need to get changes to textboxes to reflect on table

[walpy]

I am trying to create a form off my one sheet of data called "Non ICF Trainings" and I have used a combo box at the top to populate the 16 or so unbound text boxes below which show the completion dates of trainings. It works fine, but what I cannot figure out is how to get them to update the data sheet once one of the dates (or blank dates) has been updated.

Could anyone get me pointed in the right direction?

Here is what the form looks like: [Form](http://i.imgur.com/w1EbGK6.png)

Here is the (very basic) code: [Code](http://i.imgur.com/XL59H6d.png)



If need be I can send the file to better show what I've done.

Working off Access 2013

[June7]

Why are the textboxes unbound? Why do you need code to populate record?

Attaching file can't hurt.

I can't open those image links now - blocked.

[walpy]

No clue why this images wont work.. but the file is too large to attach apparently.. like 880ish kb. Here are the photos though:

Table
Form
"Code" - if you're willing to call it that.

I followed steps from this article as best I could to get to this point if I'm being honest. http://www.techrepublic.com/blog/mic...box-selection/

[June7]

Doesn't really answer my question of 'Why?'

Is the zipped file over 2mb?

Instead of VBA code, expression in textbox ControlSource property can display value from combobox column:

=[Combo0].[Column](2)

Use code only if you want to save value to record.

[walpy]

They are unbound because I am a complete novice and clicked insert textbox, and just left them. Didn't know what else I could do or should do with them. I guess I should say this is my first go with Access.

And saving the values (once they are changed or added if blank) is exactly what I am trying to get accomplished.

I apologize for my seeming complete ignorance

[June7]

Access is designed so that forms can be bound to table or query and data controls (textbox, combobox, listbox) can be bound to fields of the form RecordSource.

Data entered/edited in bound controls will pass directly to record in table. This is very basic Access functionality.

So back to the question of why using a combobox to populate unbound textboxes? What is the combobox RowSource?

Did you try running Compact & Repair then zipping the db? 2mb zip file allowed.

[walpy]

Jan6.14.zipI guess my issue, and where I went off track was I didn't know how to bind to my source table. In my head I know what I'm trying to get to, but googling old articles isn't cutting it. And not sure where a resource to learn from is. I really do appreciate you help though.

[June7]

Does this one help http://office.microsoft.com/en-us/ac...010343724.aspx

Any introductory reference book should cover these elementary features. Access Help should as well.

[walpy]

I appreciate your help and patience. I believe I've bound the Combo and Text boxes now, but when I edit them it is not being reflected to the Source Table.. care to take a look and just let me know if I'm headed in the right direction?

Jan6.14 (2).zipJan6.14 (2).zip

[walpy]

Success! It works! Thank you!