Assign Global variable in access 2007 thru coding

Question

I am having two forms OrderForm and CustomerForm.

In CustomerForm, I have a combo box, in which I select the orderId. If I click 'View' button , then it should show me a pop up which contains the order details of THIS 'orderId'

CustomerForm

orderId stored in cbxOrderId
viewOrderBut - button to display orderForm popup

I tried like below and failed

viewOrderBut click event

Forms![OrderForm].orderId = orderIdVar

Error:

Cannot find the referenced Form 'OrderForm'

my orderId variable in OrderForm is public

public orderId as string

Someone Please help me.

Editing

Code :

CustomerForm :

Public gblorderId as string



    Private Sub btnApproval_Click()
    gblOrderId = "123" 'static assignment of order id
    DoCmd.OpenForm "OrderForm"
    End Sub

OrderForm

Public orderId as string

Private Sub Form_Load()
orderId = gblOrderID
MsgBox("orderId="+orderId)
End sub

Error:

Prints...

orderId=

how to refer to CustomerForm.gblOrderId from OrderForm. I guess there i am missing.

parakmiakos · Accepted Answer · 2014-05-28 12:57:16Z

2

The error suggests that the form OrderForm cannot be found. Have you opened the form beforehand?

If OrderForm is a dialog form, then

This should be the code for your button :

orderIdVar = Forms!CustomerForm!comboBoxOrderId
docmd.openform "OrderForm"

and in the Form_load event of the OrderForm

me.orderId = orderIdVar

2.Otherwise

this :

docmd.openform "OrderForm"
Forms![OrderForm].orderId = orderIdVar

edited May 28, 2014 at 12:57

answered May 28, 2014 at 11:01

parakmiakos

3,0209 gold badges31 silver badges45 bronze badges

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

3 Comments

parakmiakos Over a year ago

@sabari add more code please. When do you open the form? is it a dialog form? I need more details.

parakmiakos Over a year ago

@sabari as you can see, your code is different from my answer. You must first open the form and then set the field. Unless the form has the modal property set to True. Then you need to do what I described in the first case.

sabari Over a year ago

Declare the global variable in Module is the perfect solution. worked.

Collectives™ on Stack Overflow

Assign Global variable in access 2007 thru coding

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related