creating a pop-up page

[Guest]

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

 

[Rick B]

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.

 

[Guest]

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.

 

[Penguin]

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.

 

[Guest]

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

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.

 

[Penguin]

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

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.