Getting the value for a textfield from a VBA variable

Question

I have a Form in wich I enter some values (project info)

ProjectInfo

The values entered in these fields, are stored in some variables in VBA when the user clicks the button:

Private Sub btnPItoKabels_Click()

    Dim Project As String
    Dim ProjectNummer As String
    Dim OpdrachtGever As String

    Project = ProjectInvoer.Value
    ProjectNummer = ProjectNrInvoer.Value
    OpdrachtGever = OpdrachtgeverInvoer.Value

    DoCmd.OpenForm "frmMain", acNormal, , , acFormAdd
    DoCmd.Close acForm, "frmProjectInvoer", acSaveNo

End Sub

Now I would like to retrieve these values in a few reports I have (they will appear in the header)

Header

These are just regular text fields.

How can I retrieve the values from the three strings and put them in these fields?

Your question is not quite clear, do you wish to store these values in a table, do a series of reports run on the back of you clicking this form's OK button? How is it the Reports relate to this form? — Matt Donnan
– Matt Donnan, Commented Jun 19, 2013 at 8:34
@MattDonnan the first picture is a Form in wich a user can insert the project info, the reports are related to the form in that the reports that are printed have a header in wich I want the project info — Gutanoth
– Gutanoth, Commented Jun 19, 2013 at 8:47

Matt Donnan · Accepted Answer · 2013-06-19 10:56:58Z

1

It's not easy to say which setup will work best for you, I suggest amending your OK button to run the reports in question.

In your reports design set for example the Project header field to:

=Forms!frmProjectInvoer!ProjectInvoer

This will then reference the values entered in your form when you open your reports, note you do not need to add the .Value to the end of the fieldname

answered Jun 19, 2013 at 10:56

Matt Donnan

5,0233 gold badges23 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Johnny Bones · Accepted Answer · 2013-06-19 15:57:51Z

1

If your form is not closed, you can easily reference them with the formula "=Forms!MyFormName!Project" (or whichever textbox you're referencing). If you plan to close the form, you can't really reference the values unless you specify them as GLOBAL, but even so they only last while the current sub is running.

answered Jun 19, 2013 at 15:57

Johnny Bones

8,5027 gold badges61 silver badges127 bronze badges

Comments

Gutanoth · Accepted Answer · 2013-07-25 12:19:15Z

0

I have done the following to solve the problem:

when pressing the "ok" button, the values in the form will be put in a new table "tempProjectInfo"

When loading the reports, the values are taken from the table and the table is dropped.

answered Jul 25, 2013 at 12:19

Gutanoth

8425 gold badges20 silver badges40 bronze badges

Collectives™ on Stack Overflow

Getting the value for a textfield from a VBA variable

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related