creating a pop-up page

  • Thread starter Thread starter Guest
  • Start date Start date
Us the OnCurrent event of the continuous form. This event fires when the
focus changes from one record to another (in other words, when you click a
record).

Rick B


iholder said:
How can create pop-up edit form. When the user click on the record
selector.
 
I need to code the On click event. When the use clicks on example; "the name
field" the a pop-up page is filtered comes up with additional info on that
record.
 
Try use this code:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "NewFormNameHere"

stLinkCriteria = "[RecordID]=" & "'" & Me![RecordID] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Hope this helps.
 
Thank you for the code. It worked in one application. Bust in a similar
application it do not work.

I go a run-time error. 2501 - The OpenForm action was cancelled. I can not
figure why this error.
Help Thank you

Penguin said:
Try use this code:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "NewFormNameHere"

stLinkCriteria = "[RecordID]=" & "'" & Me![RecordID] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Hope this helps.

I need to code the On click event. When the use clicks on example; "the name
field" the a pop-up page is filtered comes up with additional info on that
record.
 
Do you have some code in the open event of the form?

Thank you for the code. It worked in one application. Bust in a similar
application it do not work.

I go a run-time error. 2501 - The OpenForm action was cancelled. I can not
figure why this error.
Help Thank you

Penguin said:
Try use this code:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "NewFormNameHere"

stLinkCriteria = "[RecordID]=" & "'" & Me![RecordID] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Hope this helps.

I need to code the On click event. When the use clicks on example; "the name
field" the a pop-up page is filtered comes up with additional info on that
record.

:

Us the OnCurrent event of the continuous form. This event fires when the
focus changes from one record to another (in other words, when you click a
record).

Rick B


How can create pop-up edit form. When the user click on the record
selector.
 
Back
Top