List Box Error: Inadmissible value or data type.

[ejohnson442]

I'm using Open Office 3 on Windows Vista. I've been searching the web for a week now without finding a resolution to the following problem:

I populate a list box on my form as follows:

Data field: "ID"
Type of list contents: sql
List content: SELECT "Media", "ID" FROM "Media" ORDER BY "Media" ASC
Bound field: 1 (I've changed this during testing but without results)

I've borrowed code from this forum/other places and arrived at the following:

Sub applyfilter(oEvent)
dim oTxt, oListModel, myCurrentId
oTxt = oEvent.Source.SelectedItem()
msgbox (oTxt)

oListModel = oEvent.Source.getModel()
myCurrentId = oListModel.ValueItemList(oListModel.SelectedItems(0))

msgbox (myCurrentId)
end Sub

I've tried various versions of the above code based on this forum and nothing works. The results are always the following:

Inadmissible value or data type
Index out of defined range

The error message seems to suggest that perhaps the ValueItemList is not being properly populated. I would think this to be a very common task. What am I doing wrong?

[Voobase]

Hi there,

What are you trying to achieve with the macro? With the SQL which is in your listsource, it seems the listbox would be displaying the field "media" and binding the field "ID" into the field "ID", which is a field in the table (of the form) that the listbox is sitting in. This is because you have selected "ID" as the data field. I am hoping that the field "ID" (from the table of the form that the listbox is sitting in) is not a primary key field, as you would be changing the primary key value of the row of data of your form whenever you operated the listbox.

If you are trying to use the listbox to retrieve a certain row of data from your database you would need to go about it another way. You could create a "dummy table" (of 1 row of data only)and base your mainform on this table. The listbox could also sit in this form and when it is operated store its "ID" value in a field in the dummy table. You then can create a SubForm and base this on the table you wish to display. You can then use a link/join between the dummy table's field and the "ID" field of the SubForm's table. A simple macro (to reload subform) would then be required to display the record you wished. Have a look at these threads for more details.... http://www.oooforum.org/forum/viewtopic.phtml?t=72134
http://user.services.openoffice.org/en/forum/viewtopic.php?f=39&t=10036

There are also other ways to go about this but they probably require more macro. Let me know if it wasn't this and you problem was different.

Cheers

Voo

[ejohnson442]

Hmmmmm,

I guess my code fragment is a bit confusing as to my intent. The code fragment demonstrates my attempt to acquire the underlying value from a listbox selection.

The full scope of what I'm trying to do is to have a form for user input. Two listboxes are available from which to select a media type (ex., magazine1, magazine2, magazine3, etc.) and the print language (ex., chinese, spanish, amharic, etc.) of the requested media. The listboxes serve as straightford lookup (so it's ok that the "ID" is the primary key) objects.

Upon completing some prelimary client information, the appropriate selection is made using the before mentioned listboxes. Form submission creates a record, part of which contains the "ID" from each selected listbox items.

Since I am able to acquire the item selected from each listbox, I know I could use that info and generated a query to get the "ID" from the appropriate table but that's kinda kludgy. Obviously, I'd prefer to avoid that if at all possible but I could live with it.., maybe...

But if I could get the SelectedValue for the SelectedItem (as is so common for listboxes in most other UI implementations I've used), everything would be neat, tidy and meet the standards for modern programming protocol. Please tell me this can be done.

(Thank you so much for your prompt reply!)

[Voobase]

Hi again,

Luckily most things are achievable in Base. Sometimes its the long way you take until it dawns on you a better way.

[ejohnson442]

Thank you very much for your assistance. The links to sample code/projects you provided are invaluable. It seems that the issues I have are have to do with the relationships between the data sources for the forms/components. I'm disappointed with the complexity surrounding this issue but..., sigh, I'm working through it.

Thanks again for you help!