OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Replace with list box won't show data

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
markmc2
General User
General User


Joined: 31 Jan 2007
Posts: 20

PostPosted: Wed Jan 31, 2007 10:22 am    Post subject: Replace with list box won't show data Reply with quote

On Win xp sp2, oo2.1
I have a simple flat file and a form that was created with the wizard, then edited replacing some fields with list boxes. I created specific lists for those fields under control-"list entries".
All works fine, data shows, drop down lists are as I specified. Been using it for a year. I don't remember if I changed much along the way but it is likely something.

I recently added a field to the data base, it shows in the table, it shows the data for all entries. Problem I'm having is adding it to the form.

IF I add it as a text field to the form it shows data,
IF I create it as a list box AND leave it as a SQL query it shows the data but the drop down list becomes rather lenghty.
BUT
When I try to define the item list, the way I did in the other fields, I get a drop down list that has what I want , but the existing data won't show up.

I left several controls on the form to see what happens
I can make a new record, use the drop down list I created to enter data, the data shows on the tables, but when I refresh ...the data disappears from the drop down field but will show up in the text field. Still shows correctly in the tables.

As far as I can tell all settings for the new list box are the same as all others I made. I've tried creating the control different ways, copying and pasting it, new control, replace with....
Any help apprecitated.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group