<resending because it has not appeared and I really need help> OOo 2.03, Ubuntu-Dapper amd-64
I have spent the past day and a half trying to create a three-page form with controls linked to a database. This should not have taken more than two or three hours, but I am vexed with things that do not work and I can't figure out the fixes. I hope someone who understands how to link controls in a form to a table in Base can figure out what is wrong, because pretty soon I'm going to stroke out from frustration. 1) I have created a form with 50 combo boxes with drop-downs. Each combo box is given a unique name by numbering them in the Properties box, e.g., ComboBox01 through ComboBox50. They are tied to a field "IPA" in a table "Test_Table" created in Base which has 105 records. Everything is working fine except that the controls are not independent. Whatever the user selects in any of the boxes appears immediately in the other 49 boxes. I thought that giving them unique names would make them independent, but apparently there is something else I must do. What is it? 2) I am trying to "refresh" the database. For example, I decide to change one of the records, but the combo box still shows the old data. I have resaved the form, but the combo box still sees the old data. Eventually it updates, but I can't figure out what the mechanism is. I must eventually be doing whatever it is that causes the combo box to update itself to the database, but what is it? 3) <Original problem #3 in first post has been fixed, albeit with a couple hours work recreating the database.> When I try to use the controls the data in the controls does not appear in the order in which I have it sorted in the database. More specifically: This is a form for practice in Phonetics and the International Phonetic Alphabet. The 50 controls mentioned above are linked to a fields "IPA" in the "Test_Table" table. "Test_Table" contains 105 records, each with an IPA character in the "IPA" field. Now, if you sort the table on this field with a normal sort it will come out very hard for the student to use. That's because it seems to sort it according to Unicode specification or something. The characters appear in very random order. I have created a different sort order, where all the "a" and "a-like" characters appear first, then the "b" and "b-like characters," and so on. I did this by adding a field called "Number" which contains a number for each record. Then I sorted the table based on "Number" and the characters now appear correctly in the database (when I look at it in the browser with F4). This makes it much easier for the student to find the right character. The problem is that when I try to select a character in the control the order is not my sort order. Nor is it the order in which the characters were originally typed into the database. Nor is it by Unicode specification. I don't know what it is. I just know that the characters are appearing pretty random, which makes it really hard to use. I need to force it to display the characters according to "Number". To solve this problem I tried Form > Sort and specified the "Number" field in the "Test_Table" table. But the control is ignoring the sort specification that I entered in Form > Sort. Then I tried changing the SQL statement for the form by adding "ORDER BY "Number"." Again, no joy. Does anyone know how to get the records in a form to appear in a particular order? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
