Passing a prameter in Access from a form (1 Viewer)

[chris_elevate]

Hi,

I'm creating a mdb for a DVD hire company.

I'm trying to create a form which loads on startup (done this part)... which will let the user select which branch they are using (one of three) and then proceed to another form. When the user selects the branch '' I want the system to store the branch name and use it in the label which follow.

Attached are two pictures to illustrate.

Hope it makes sense what I'm trying to do.

I guess it's got something to do with passing the parameter from the welcome screen and then using that variable on other forms?!?!?

 

[boblarson]

The EASIEST way is to have a hidden form with an unbound control to store the value in and then you can refer to it from any form. It also guarantees against a public variable changing, or losing its value, in certain conditions.

 

[chris_elevate]

Thanks,

How would I go about doing this in this instance then?

 

[sierra467]

Another thought

I do not have too much experience, but if you use a DoCmd to open your form and use the OpenArgs argument to pass the name you want to use in the new form's Load event, it might be an other way to go.

Sending Form's DoCmd

DoCmd.OpenForm "FormName", , , , , , "DataYouWantToPassToOtherForm"
'Or in your case
DoCmd.OpenForm "frmTM_Customer", , , , , , "Brackley"

Receiving Form's Load Event

Private Sub Form_Load()
    MsgBox "The Item you are passing is: " & Me.OpenArgs
    'or maybe you could assign it to a Global or Local variable like this?
    Dim strBranch as String
    strBranch = Me.OpenArgs
End Sub

Just a thought.