Sorry for asking this here but...

[scotty85_2000]

the folks at the database forum were taking their time replying so...

Thanks to honeybee and barkk for answering my earlier questions.

I've now got a database program running which allows you to view, add/edit and delete records from an access database. However, you view them on one form, add/edit on another and delete on another. When I add a record, I can view it fine. When however, I delete a record, there is a gap left in my database so that when I attempt to add or edit again my program crashes and I get the message "Runtime Error 524: "Record is Deleted" or something similar.... Anyone got any ideas what the prob is and how do I fix it?

Also, I have another question...
I'm making an editor for a football manager game that a friend made, and there are two separate tables on the same access database, one called players, one called rosters. In the rosters section, you pick the players from a series of combo boxes with the entire player database in them, unfortunately the combo box is completely unrelated to the actual players table, and the options are nothing more than text... (is anyone following this? How do I make it so that the players are chosen from the players table but then register as part of a team in the rosters table?

Cheers...

[HeSaidJoe]

After you delete the record you have to refresh your dataset. Not sure of ADO but in DAO it's
Data1.Refresh...that should correct the situtation.