"Edit List Items" won't save

[JWhyte]

Hey all,

I'm having a very specific problem trying to add an item to a list on an Access form. The database was created by an employee who no longer works here, and I've been left "in command" with absolutely NO experience with VBA coding. I've just been learning by trial and error.

So the problem I'm having is with SAVING an edit to an "unbound" list. I add a new item using "edit list items" in Form View, and everything functions correctly by displaying the values I'm expecting with this query. I save my changes using CTRL+S, but the item vanishes if I switch to another menu or tab within the database and back again.

Using Design View I tried the same procedure, adding the new item using "edit list items" and checking that it is also present in the Properties, Row Source.

Now the really funny thing is after the new item vanishes from the Form View it is still present in the Design View. There must be something I'm missing.

I have screen shots of this whole explanation if needed.

Please help!

 

[JHB]

It sounds like the items in the list is added from some VBA code in the form.

 

[missinglinq]

I'm having a hard time following your scenario, exactly...but changes made to the design of this type of Object, unless made in Form Design View, only hold ture for that session of the Form...the changes aren't permanent.

Linq ;0)>

 

[JWhyte]

It sounds like the items in the list is added from some VBA code in the form.

I honestly can't find this list (or any list) in the code

To make it more confusing, in this database we have two nearly identical products we work with, and one already has the list item. I'm just trying to add it to the other. Seems easy, right? Just find the code for the 1st product and copy it for the 2nd. But the database designer created 1 form of code for both products. It's hard to explain.

:banghead:

 

[JWhyte]

I'm having a hard time following your scenario, exactly...but changes made to the design of this type of Object, unless made in Form Design View, only hold ture for that session of the Form...the changes aren't permanent.

Linq ;0)>

Thanks for your response. I have tried adding the list item in Design View. But it still won't appear when I switch back to Form View.

I've added some screen shots (attached).

 

[MajP]

The way you describe it, it really sounds that somewhere that listbox is being loaded by code. The code would overwrite what is in the recordsource. Go to vba and use the search feature (entire project) for the listbox name see if you can find any reference. There could be some code calling it that is on a different form or standard module.

 

[jdraw]

JWhyte,

You may get some ideas from this free youtube video by Richard Rost re Combobox Edit List Items

Good luck

 

[JHB]

I honestly can't find this list (or any list) in the code
...

Does the button "MC" have any event handler, (looking at you pictures, for me it still looks like it created by code)?
Else post you database with some sample data or create a new database and import the form with the problem into it, zip it.