If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access XP, Continuous Forms, Record position
First the data is comming from a SQL 2000 database.
I have a parent form with a subform. The subform is showing records directly from a table and it's default view is set to continuous forms. The parent form has add, edit and delete buttons. The add and edit buttons bring up an edit window so the user can modify the data. After and add/edit window is closed I call subform.Requery so that the subform reflects the addition or edit that the user made. I would like the new record or the edited record to now be selected on the subform. As an example...after a new record is added I call subform.Form.Recordset.MoveLast. Which does indeed select the last record in the list of continuous forms. The problem is if I then try to edit that record in that subform (just a CheckBox in this case) Access blows up completely and has to repair the database. Where have I gone wrong? Kyle! |
Thread Tools | |
Display Modes | |
|
|