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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pop-up form that creates record that links 1:1 to main form 0
Resize Pop Up Form 4
Link pop up form data with main form data 3
Refresh Pop up 2
Access Automatically Send a notification email once a record is added 0
DELETE FROM a table WHERE... 1
Multiple records that contain a checkbox.One record should be chec 4
Requery a background form 2

Back
Top