I have a button which opens a form with one subform when clicked. Both, form and subform, show some data from my DB. Now I want to set the cursor (the selected row) to a specific row. For the form I use "DoCmd.GotoRecord(...)" which works fine. When accessing the subform, however, the "GotoRecord" method will not work. By accessing the subform directly (with Forms.MyForm.MySubform) I can get the current position, but not set it.
I'm sure that this is a quite simple problem with an obvious solution, but I spent hours on it without finding a solution. I would be very pleased by every hint.
Maybe I should me more detailled... The subform I use was created with the design assitent and looks a bit like a datagrid, which means that the user can see every row and column of a table (the datasource). The user can also select a row by clicking on it, and there's a cursor which shows the selected row. When the subform is opened, always the first row is selected. Now the only thing I want to do is automatically select another row in the opening step, without changing the contents of the table (just an UI issue).
English is not my first language, so please write if something is still not clear.