Edit List Items (1 Viewer)

Fira_g

Registered User.
Local time
Yesterday, 21:21
Joined
Oct 17, 2019
Messages
60
I am trying to utilize the built in function "List Items Edit List" that opens another form to Edit/Add new record.
The problem is when i return to the main form it does not appear in the list of records of that combobox.

Any suggestions how to solve this out?
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:21
Joined
Oct 29, 2018
Messages
21,454
Hi. Just to make sure I understand, did you mean "List Items Edit Form?" If you really mean List Items Edit List, is your Row Source Type a Value List?
 

Fira_g

Registered User.
Local time
Yesterday, 21:21
Joined
Oct 17, 2019
Messages
60
It is List Items Edit List and the source is a query.
 

Attachments

  • ListItem.jpg
    ListItem.jpg
    85.4 KB · Views: 125

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:21
Joined
Oct 29, 2018
Messages
21,454
It is List Items Edit List and the source is a query.
Hi. LOL. You insisted it's a "List Items Edit List" and yet the image you posted highlighted the "List Items Edit Form" property. In any case, is frmCustomers set up as a Data Entry form? Meaning, is the Data Entry property on that form set to Yes?
 

Fira_g

Registered User.
Local time
Yesterday, 21:21
Joined
Oct 17, 2019
Messages
60
You are right:eek: Form.

The property for the Data Entry is No at the moment, but it did the same for it set as a Data Entry Form as well.
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:21
Joined
Oct 29, 2018
Messages
21,454
You are right:eek: Form.

The property for the Data Entry is No at the moment, but it did the same for it set as a Data Entry Form as well.
Okay, give me a minute to see if I can duplicate it on my end...
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:21
Joined
Oct 29, 2018
Messages
21,454
Hi. I just created a quick demo to see if I can duplicate your problem. Take a look at the attached and try the following steps:

  1. Open Form1
  2. Click the Edit List button
  3. Enter a value in f1 and f2 fields in the popup form
  4. Close the popup form
  5. Verify the values you just entered shows up on the list
Let us know how it goes...
 

Attachments

  • ListEditForm.zip
    26.3 KB · Views: 121

Fira_g

Registered User.
Local time
Yesterday, 21:21
Joined
Oct 17, 2019
Messages
60
Following the steps, the value does show up on the list.
Does it make any difference that I have a combobox/dropdown?
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:21
Joined
Oct 29, 2018
Messages
21,454
Following the steps, the value does show up on the list.
Does it make any difference that I have a combobox/dropdown?
Okay, I think I understand your question now. Were you asking not how come the values don't get added to the list, but more like how come the new values are not automatically selected from the list? If so, that's not the function of the List Items Edit Form. It's just used to quickly add more options/rows/items to the list. If you want to auto-select the new item, you could try using the NotInList event (and some code).
 

Fira_g

Registered User.
Local time
Yesterday, 21:21
Joined
Oct 17, 2019
Messages
60
No, I just want it to appear on the list from the dropdown.
I just tested it on the test DB I have and it works there. That means it has something to do with the form on my current DB :(
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:21
Joined
Oct 29, 2018
Messages
21,454
No, I just want it to appear on the list from the dropdown.
I just tested it on the test DB I have and it works there. That means it has something to do with the form on my current DB :(
Right. I guess so too. I added a combobox to my demo and the new item showed up right away. You might try replacing your combo with a new one, just in case it helps.
 

MajP

You've got your good things, and you've got mine.
Local time
Yesterday, 21:21
Joined
May 21, 2018
Messages
8,525
I will take a look later. One thing you have to use the class requery and not the control's requery
for a complicated reason
 

MajP

You've got your good things, and you've got mine.
Local time
Yesterday, 21:21
Joined
May 21, 2018
Messages
8,525
See your other thread
Will your code from that thread address the issue I pointed
No, the other thread explains why.
 

Users who are viewing this thread

Top Bottom