Pop-up form not showing current record

[west]

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?

[pbaldy]

One way:

BaldyWeb wherecondition

You can use the Where argument of your macro if you want to stay with that.

[west]

Thanks a lot!

It took a little time but finally I got it working. This is a very good
piece of coding.

-JC

[pbaldy]

Excellent, glad it helped you.