Displaying Form Data on another Form

[Banshee]

Hi everyone.



I've created two forms, a button on the main form opens the second one. The second form asks for a number, the measurement used for the number and two other pieces of information just needed for that form. The first two pieces of information I want to have displayed on the main form but I cannot seem to figure out how to do it.

Thanks in advance!

[mcktigger]

Hi Banshee

If I understand this correct you want to transfer info from form1 to form2 when you click cmdbutton?

If so on the click event of the command button after the Docmd.openform xxxxxx

Forms!Form2!fieldNumber = me.fieldnumber
Forms!Form2!fieldMeasurement = me.fieldmeasurement

This assumes form1 is still open when form2 is opened.

[Banshee]

Hello mcktigger,

Not quite, I want the two of the choices made on form 2 to appear on form 1 when it closes. Sorry I didn't make sense the first time!

[mcktigger]

hi

assuming form1 is always open when form2 is open you could put this code on the On Close event on form2:

Forms!form1!field1 = Forms!form2!field1
Forms!form1!field2 = Forms!form2!field2

You could also put this on the On Click event of the cmdbutton

Hope this helps

[Banshee]

That's pretty much got it, the code works perfectly but I'm an awkward person and want both fields 1 and 2 on form 2 to go into one field on form 1... I can't help being a pest!

[mcktigger]

hi

On the On Close event put the following

Dim strfield As String (creates a variable to temporary hold field1 & field2)

strfield = Me.Field1 & " " & Me.Field2 (puts the data into the variable)
Forms!frmForm1!Field1 = strfield (transfers the variable to form field1)

Note: if no space is needed then take out " "&

hope this helps

[Banshee]

mcktigger

I love you