List Box won't update table

[nate_03]

I have created a List Box on a Form in the hope that when the user selects an item (Dept) from the list Box it updates the table which I have it linked to (Employee Table). I have tried creating a query containing just the items I want displayed(Dept) in the List Box and (through Lookup Wizard) selected the option to have the selection stored in my database (Employee Table). For the life of me it will not store the data in the table. The field remain blank. If anyone has any suggest I would be more than thrilled!

Thanks,

Nate_03

 

[Mile-O]

Have you used the listbox's ControlSource property to bind it to the table in question?

 

[nate_03]

Yes I did, went into properties and selected the field i want the info to save to.

 

[dcx693]

Can you please post the field's control source and rowsource info here so we can examine it?

 

[nate_03]

Here is the field's control source:
=[Dept ID]

Here is the field's rowsource:
SELECT [Dept ID for Employee Table].[Dept ID] FROM [Dept ID for Employee Table];

And Row Source Type is:
Table/Query

Again, the Dept_ID and Office_ID fields will not update when I try to add info using a list box.

Thanks in advance for any help!!

 

[Pat Hartman]

The control source should contain only the field name. No = sign.

 

[nate_03]

Even after removing the = sign in the Control Source it still does'nt work

 

[Mile-O]

Take the brackets off the ControlSource, too.

 

[nate_03]

Removing the brackets was also a failure.

I have given up on the list boxes and moved onto the Combo Box and it seems to be working fine.

Thanks for your help guys!

 

[Pat Hartman]

If your text box was not storing a value to the table, it was because its multi-select property was set to something other than single.