Open pop-up form from field value on Continuous form

[vad77]

I want to open a pop-up form where the form opens up to the order id I clicked. The order_ID field is set to hyperlink and used VBA code on the click event to open the frm_NewOrders form.


The problem is when I click on an order ID it opens the new orders form but in Add mode and not to the order ID I clicked.
I tried two version of my code.

DoCmd.OpenForm "frm_NewOrders", , , "[order_id]" = Me.Order_ID

DoCmd.OpenForm "frm_NewOrders", , , "[order_id]" = Me!Order_ID

If I take out the Where condition from the event the new orders form will open up to the first record.

Any ideas?? I did do a compact and repair but no change.

Thanks!!

[RuralGuy]

Why do you have the order-id field set as Hyper Link? Just leave it as a text field and try it. Is the OrderID a numerical field? If not then you will need to surround the value with quotes.
DoCmd.OpenForm "frm_NewOrders", , , "[order_id] = '" & Me.Order_ID & "'"

In any event, your syntax is off a bit. Look at the example I posted.

[vad77]

My Order_ID field is an auto number field and is the primary key of the orders table. I made it hyperlink so the user will see that it is clickable. Fixed the syntax and now it works.

DoCmd.OpenForm "frm_NewOrders", , , "[order_id] =" & Me.Order_ID


Thanks for the reply.

[RuralGuy]

That's great! I marked this thread as Solved for you.

[vad77]

Yeah, stupid syntax error. Now my next task, reporting.

Thanks again!