bobunknown
Registered User.
- Local time
- Today, 07:53
- Joined
- May 25, 2018
- Messages
- 77
Hi all,
As the title says I am trying to open a form (as a pop up window) from inside another form. For context the main form is called 'Trade_Waste_Address' and the form im trying to open is called 'Notes'.
Each has their own ID field called 'ID' & 'NoteID'. Im attempting to call up the 'Notes' form based on the current records 'ID' but it doesn't seem to want to play ball so far.
Here is how far I have gotten:
The issue im encountering is with having the current form 'ID' automatically recognised. As of right now when I click the associated button this code will create a pop up box prompting me to manually entre the 'NoteID' in order for the record to then be called up and displayed.
I have tried a few different variations now but with no success. Any help would be appreciated.
As the title says I am trying to open a form (as a pop up window) from inside another form. For context the main form is called 'Trade_Waste_Address' and the form im trying to open is called 'Notes'.
Each has their own ID field called 'ID' & 'NoteID'. Im attempting to call up the 'Notes' form based on the current records 'ID' but it doesn't seem to want to play ball so far.
Here is how far I have gotten:
Code:
Private Sub Command291_Click()
DoCmd.OpenForm "Notes", , , "NoteID = " & Me.ID
End Sub
The issue im encountering is with having the current form 'ID' automatically recognised. As of right now when I click the associated button this code will create a pop up box prompting me to manually entre the 'NoteID' in order for the record to then be called up and displayed.
I have tried a few different variations now but with no success. Any help would be appreciated.