Form pop up

[mlamont]

I have a form with a table behind it, i would like to have a button so that when a user clicks on it a smaller form pops up and any information that is entered is saved in the record on the previous screen/form. Both forms would have the same record source. Is that possible and how can it be done?

Cheers,

Mike

 

[Adrianna]

I don't really understand what the problem is, but here goes:

You have a main form and an additional "small from" with the same record sources.

You've possibly created a command button to open the second form:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "SmallFrm"

stLinkCriteria = "[PrimaryKey]=" & Me![PrimayKey]
DoCmd.OpenForm stDocName, , , stLinkCriteria

This will open the second for on the same record as the first form!

Hope that is what you were trying to ask...if not...please restate the question!