I have a demographic (tblMain) table with this fields:
- CaseID – AutoNumber
- Name – Text
- Address – Text
- Phone – Text
- NotesID – Number (Linked to tblNotes.NotesID)
In another table (tblNotes), I have:
- NotesID – AutoNumber
- Notes – Memo
In the Main Form I placed a control button (cmdNotes) to open a pop-up
form in wich user can write the notes.
The pop-up Notes Form has:
- tblMain_NotesID
- tblNotes_Notes
The embeded macro code produced by the (cmdNotes) button control wizard:
Action:
- OpenForm
Action Arguments:
- Form Name – Form Notes
- View – Form
- Filter Name -
- Where -
- Data Mode -
- Window Mode – Normal
The problem: Every time I click the (cmdNotes) control button the pop-up
form goes to the notes of the first record. What I'd like it to do is to go
to the notes of the current record.
Any thaughts?