List Box selection not entering data in table

**MFS** · 03-19-2013, 09:29 AM

Something weird here is happening. . . .

I added a list box that references names of employees from an employee table and is supposed to then input the referenced name onto another table when I save the form, but is not doing so. In the past I have had no troubles with doing this but now for some reason I cannot. Does someone know of a way to correct?

**pbaldy** · 03-19-2013, 09:38 AM

Is it multiselect? Does it have a control source?

**MFS** · 03-19-2013, 09:44 AM

No only can choose one Employee
Yes, the control source is the name of the employee to the table I want to send that name to.
It works immediately after generating the list box for the 1st time, but then never again. ????

**pbaldy** · 03-19-2013, 10:18 AM

I'm stumped then. Can you post the db here? Or maybe try a decompile first:

http://www.fmsinc.com/MicrosoftAcces...Convention.asp

**MFS** · 03-19-2013, 10:39 AM

A few moments ago I reloaded Access on my computer. At the moment it seems to have taken care of the issue.
I'm going to keep this thread open until later today until I see if the problem returns.
Thank You for your support pbaldy.

**pbaldy** · 03-19-2013, 10:59 AM

No problem.It was odd for it to work once and never again.

**MFS** · 03-19-2013, 11:03 AM

Yes it is, I tried adding and deleting the list box numerous times with the same results.
So far everything is still working

List Box selection not entering data in table

Thread Tools

List Box selection not entering data in table

Similar Threads

Entering data into table using a form in Access 2010

Updating drop down list after entering data

retrieving data from other tables in combo and entering it into a different table

Update table based on List Box selection

Showing drop down list while entering data in a field

Posting Permissions