Setfocus to the combobox if a certain criteria is met

[nhdee]

Thanks but I don't want it as an unbound text box. It wouldn't work anyway. Do I have to use Open Args or is their something easier? I have tried:
DoCmd.OpenForm "Gift Certificates", _
WhereCondition:="Price=" & Me.GCAmt

I get a Compile Error: Method or data member not found...

[nhdee]

I also tried:
DoCmd.OpenForm "Gift Certificates", , , , , , Me.Price

With the following:
Private Sub Form_Load()
If Not IsNull(Me.OpenArgs) Then
Me.GCAmt= Me.OpenArgs
End If
End Sub


Get same compile error.... ????

[ItsMe]

Thanks but I don't want it as an unbound text box. It wouldn't work anyway....

What are you trying to do? Are you trying to pass a value that is on a textbox on one form to another or open a form with specific criteria?

[nhdee]

This is a cash register database. The user enters the items being sold on the subform and IF they sell a gift certificate (selection from a combobox) it will open a gift certificate form that can be printed to give to the customer. That part is now working perfectly (see above). I am trying to take the price of the gift certificate sold, from the subform (price), and transfer it to the gift certificate form (GCAmt), which is a popup form.

[ItsMe]

If the previous form is still open, you can reference it and its controls. You don't have to use openargs

Maybe something like this in the PopUp form's load event, as long as the form is dedicated to the OrderDetails form

Me.Price = [Forms]![OrderDetails]![sbfOrderDetails].[Form]![Price]

[nhdee]

I have tried that and it doesn't work. How do I direct Access to the Price of just the Gift Certificate?

[ItsMe]

How do I direct Access to the Price of just the Gift Certificate?

You need to get the form and control names correct. I was just guessing on the names with the example I provided. Perhaps this can guide you to get the names correct.
http://access.mvps.org/access/forms/frm0031.htm

[nhdee]

I changed what you had. The Main Form is OrderDetails. The SubForm is called SubDetails (Source Object) and the name is sbfOrderDetails. The subDetail form has a combobox called Department, and text boxes for Quantity & Price (both control source & Name are the same for everything on the subdetails form). If Gift Certificate is chosen from the department then the Gift Certificates form will open. On the Gift Certificate Form GCAmt is where I want the price from the subdetail form to go....

[ItsMe]

Then this should work in your popup form's load event

Me.GCAmt = Forms!OrderDetails!sbfOrderDetails.Form.Price

[nhdee]

That's what I thought and what I had used but it doesn't work. Thanks though. I am thinking I need something more specific like what I got for the recordset clone: .FindFirst "Department='Gift Certificate'" so it knows to go to the department that has gift certificate and get the price from that... not sure what to use? I know if I manually put my mouse on the Gift Certificate row in the subform to select it and have = [Forms]![OrderDetails]![sbfOrderDetails].[Form]![Price] as my default in the Gift Certificate GCAmt it WILL bring in the correct amount. But how to do that programmatically???? Something else with bookmark?

[ItsMe]

my mouse on the Gift Certificate row in the subform to select it and have.....

If the subform is a continuous form or a form in DS view, you need to go to that specific record. When you click on a control or record within a continuous form you set focus and, in essence, select the record. Maybe there is a way you can get the value you need into a single, unbound, textbox control or into a variable that can be passed in open args or through the form's load event.

Before you can think about passing the value to another form, you need to isolate it somewhere. An unbound textbox may be the simplest. It may help you to visualize that the correct value is available.