Opening pop-up from subform records?

[NewShoes]

Hey all,

Basically, I have a subform and each row in that subform has a little button. What i'd like is a popup form to appear when that button is pressed which displays a comments field for that particular record. Each record (and therefore row) has its own ID so I guess I need to link the popup form to that ID?

Any nudge in the right direction would be great

-NS

 

[vbaInet]

There are a couple of ways, but to start you off you can use:

Me.[COLOR=Red]TextboxName[/COLOR].SetFocus
DoCmd.RunCommand acCmdZoomBox

Put that in the Click event of the command button. Amend the bit in red.