Field Clears Automatically

[leo1]

I have a form that the field Lead Status goes blank. When I click to the next record and come back the selection I made from the list box is gone. Any ideas on what to check first? It might be a table issue or form issue.




By lsearcey at 2008-05-28

[kabing]

We need some more information before we can help you:

-What version of OOo are you using?
-On what Operating System?
-Are you using the embedded database or connecting to an external data source?
-If an external source, what kind and what sort of connection?

Are there any macros attached to any of the list box events?
Have you checked to make sure that the listbox relates to a field in your table? (check table properties)
Check the Data tab of the control properties window for the list box. What do the various fields there say?
(to open the control properties window, open the form for editing; right click on the list box control and choose Control... from the contextual menu)

kabing

[leo1]

I am using version 2.3
Windows XP OS
Embedded database

No macros


Heres the data tab:


By lsearcey at 2008-05-29

And the field in the table it populates in the table but not the form



By lsearcey at 2008-05-29

[kabing]

Thanks for the additional info. The Properties box is a little hard to read, but I think it's set up wrong.

What are you using (or wanting to use) as the source for the list?

kabing

[Villeroy]

Type of content: "Value list" is not what you want. A value list would be typed into the next box "List Content". From what I read in you screenshots, you want this SQL string:

Code: Select all

SELECT DISTINCT "Lead Status" FROM "BizContacts"

Compare also with the working list boxes.

[leo1]

What are you using (or wanting to use) as the source for the list?

The source for my three options are in the general tab I think its called list content. I just type in the option and hit Shift enter.

[leo1]

Sorry the choices are stored in List entries section, should I still use the list entry area to store my options or try what Villeroy suggested? If I use Villeroy's Idea where do I put the string?

List entry in general tabe:


By lsearcey at 2008-05-31