We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

List Box - List entries not syncing with List content [closed]

asked 2017-01-02 16:55:09 +0200

DougKMiles gravatar image

I have several List Boxes where I have a Value List of numbers in List content under the Data tab, and then corresponding text in the List entries field under the General tab. e.g. 0 = "Open", 1 = "Closed" etc.

(I'm using the numbers in the fields because they are accessed by several queries which only seem to work with numbered fields.)

When I first set them up, they seem to work fine showing the text in the listbox on the form and entering the corresponding number into the table field. However when I click back into design mode or close the form and then reopen it, they quit working. The only number they'll enter into the table field is 0 no matter what is selected in the list box.

I wonder if anyone has any insight into why this might be happening?

Many thanks in advance for any ideas or assistance.


edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-09-20 11:18:28.090478


Here are some ideas to possibly help you figure this out: Can other fields enter data into this same table properly at that point? And what is the type of field you're entering this into, e.g. integer, ... ?
What if you change that field type to variant (or repoint the listbox to a variant field to test it with). And if you also create a non-list box for this same field, can you then enter a value into it directly? Does that work?

EasyTrieve gravatar imageEasyTrieve ( 2017-01-02 18:54:22 +0200 )edit

Thanks for the suggestions. I change the field type from integer to Text var, and it seemed to be working. But after working with it for a while, it snapped back on it's own to just entering zero into the table filed whatever was entered in the list box field.

I checked out the link provided by Ratslinger below, but it seems like @pierre-yves samyn is having the same problem with no better results.

DougKMiles gravatar imageDougKMiles ( 2017-01-15 21:25:43 +0200 )edit

@DougKMiles - Just saw this comment today as messaging in this forum is a bit screwed up! I downloaded the sample in the mentioned post and it works perfectly for me. I even changed the letters to numbers and again no problems whatever I try. You have never mentioned your OS or LO version and also if Linux is this a distro version of LO?

Ratslinger gravatar imageRatslinger ( 2017-01-21 01:30:04 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-01-02 17:40:50 +0200

Ratslinger gravatar image

Don't understand what you problem is with the query - maybe something in your statement.

Here is how the listbox should be set (this example used letters vs numbers):

image description

image description

For a working sample of this click here and select the sample in the answer provided by @pierre-yves samyn.

edit flag offensive delete link more


Thank you Mr. R! Yes, that's pretty much exactly what I have except using numbers. Weird. I'll check out the pierre-aves samyn sample.

DougKMiles gravatar imageDougKMiles ( 2017-01-02 18:35:55 +0200 )edit

Question Tools

1 follower


Asked: 2017-01-02 16:55:09 +0200

Seen: 320 times

Last updated: Jan 02 '17