Hello,
Please help me with this if you can:
- On "myFormA" is a ListBox named "lstMyListbox" (column 0 is primary key same as myFormB).
- Another form, "myFormB", is a SingleForm(view) which shows records from a query.
- On "myFormB" the PrimaryKey field is "txt_myPK".
- Also on "myFormB" I have Prev/Next cmdbuttons (RecordGoToNext, etc.)
- On the DoubleClick event of lstMyListbox (on "myFormA") I have the following:
This works as expected; for example: myFormB opens at "the 7th record in the list" as selected from myFormA(lstMyListbox).
ie. myFormB is now filtered. (I think).
The problem is that if i now click the "RecordGoToNext" button, it will not go to "the 8th record", but instead goes to the 1st record. And then the 2nd record, etc.
I think this is something to do with "Bookmark" but I don't know how to implement it.
Please help me.
Thank you.
Jamie.
Please help me with this if you can:
- On "myFormA" is a ListBox named "lstMyListbox" (column 0 is primary key same as myFormB).
- Another form, "myFormB", is a SingleForm(view) which shows records from a query.
- On "myFormB" the PrimaryKey field is "txt_myPK".
- Also on "myFormB" I have Prev/Next cmdbuttons (RecordGoToNext, etc.)
- On the DoubleClick event of lstMyListbox (on "myFormA") I have the following:
Code:
DoCmd.OpenForm "myFormB", , , "[txt_myPK] =" & Me.lstMyListbox
DoCmd.Close acForm, "myFormA"
This works as expected; for example: myFormB opens at "the 7th record in the list" as selected from myFormA(lstMyListbox).
ie. myFormB is now filtered. (I think).
The problem is that if i now click the "RecordGoToNext" button, it will not go to "the 8th record", but instead goes to the 1st record. And then the 2nd record, etc.
I think this is something to do with "Bookmark" but I don't know how to implement it.
Please help me.
Thank you.
Jamie.
Last edited: