Recently modified a table and now my form is goofy

[bellczar]

I make very few mods to my database. Recently I added a field to a table and a form that links it. Since then the form has acted strangely. Usually the form pulls up the table in alphabetical order by the key field (called title) so when I open the database, the first record alphabetically is displayed on the table. Now it is not.



Furthermore, when I use a field in the table to pull up a record, often it doesn't pull up the record I want and instead pulls up the first record in the table that matches the substring I typed. This means that records whose title is short of that first matching substring are inaccessible through the form.

When I add a new record to the table via the form, it's supposed to update instantly after I press enter for the third time. Instead the form advances to the next record in the table.

What did I forget to do?

[June7]

Records do not have inherent order. Apply sort criteria if you want a particular order.

Assume you added a new control to form. Probably need to change TabOrder property.

[ssanfu]

Thought I'd put in my $0.02 worth.....

Records do not have inherent order. Apply sort criteria if you want a particular order.

I agree with June. This is why my forms are based on queries instead of tables.