Order of Records in a Sub Form Table? Macros!

[Reimondo]

Hi,

I've got a sub form table which is created via a "create table" button on the form which is linked to a macro. The macro just contains a series of runSQL actions which insert records into the database and I then have a "ShowAllRecords" action at the end which refreshes the table and displays the newly inserted records.

But my problem is that occasionally the table does not display the records in the same order they were inserted.

Any one know why this might happen?
Most of the time, it will display the records exactly in the order I inserted them by. As I don't have any sort filters or anything on the tables so they should just display the records as inserted?


The second problem i have is that when i am creating a new record, I have to run the macro twice in order for the records to be displayed in the table (and for the data to be inserted into the database)? Which effectively runs the series of runSQL statements twice and inserts them in twice.
But if it is not a new record, I can simply execute the macro once, and it inserts the records into the database and displays the new records with no problems at all?


Any help with any of these problems will be most appreciated.

Also, as I'm not very familar with VB, then non-VB advice will be most appreciated.


Thanks,

Raymond

 

[JeremyNYC]

Raymond,

I just answered this post in another forum. I'm sure you didn't mean to do anything wrong, but it's generally considered rude to post the same question in two forums, because it can easily lead to two people spending their time answering your question, instead of one. And that's frustrating for the people who give up their time to answer people's questions here. As I said, I'm sure you didn't mean to be doing anything wrong, I just wanted to ask you to try to be aware fo this in the future.

Jeremy ==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.