Click on record, pop up form

  • Thread starter Thread starter MaryMalone
  • Start date Start date
M

MaryMalone

I have a datasheet subform that I want to be able to click on the Project
number in the record and have a form pop-up. I have the form built and the
macro for the open form on the project number, but I am having trouble
associating the record I clicked with the record that should show on the
form. (They use the same query and same data so it should be an updateable
record) The problem is that when I click on the record, the form pops up with
no information.

Any thoughts? I think it has to do with the way the expression is set in the
OpenForm macro but I cant figure it out.

Thanks!
Mary
 
I would add some code to the On Click (or Double-Click) event of the control
in the subform like:

DoCmd.OpenForm "frmName", , , "[ProjectNumber]=" & Me.ProjectNumber, ,
acDialog
 
Back
Top