setfocus to subform

G

geno

Registered User.

Local time

Today, 06:59

Joined

Jun 19, 2000

Messages

243

• Jan 24, 2003

• #1

Hi, I have a form with a subform, when the user enters into the subform, unitprice field, I have another form open with pricing info on the product. I would like to have the focus go from the pricing info form back to the unitprice field on the subform. I found this code on this forum but I can't seem to get it to work.

Forms![Orders]![order details subform].Form![unitprice].setfocus

The pricing info form still holds the focus.
Thanks

 

R

Rob.Mills

Registered User.

Local time

Today, 01:59

Joined

Aug 29, 2002

Messages

871

• Jan 24, 2003

• #2

Is the Pricing form Modal property set to yes? If so, this form won't let anything else take the focus while it's open. Leave the pop-up property to yes but set modal to no.

 

G

geno

Registered User.

Local time

Today, 06:59

Joined

Jun 19, 2000

Messages

243

• Jan 24, 2003

• #3

These setting are already set to what you suggested. Any other ideas?

 

R

Rich

Guest

• Jan 25, 2003

• #4

Screen.PreviousControl.SetFocus

 

G

geno

Registered User.

Local time

Today, 06:59

Joined

Jun 19, 2000

Messages

243

• Jan 25, 2003

• #5

Where would I put that code?

 

G

geno

Registered User.

Local time

Today, 06:59

Joined

Jun 19, 2000

Messages

243

• Jan 30, 2003

• #6

Hi, I still can't get this to work and it's about the last thing that I have to do before rolling out this database. I've searched this site and others but no luck on getting this to work. Can anyone help.....Thanks

 

R

Rob.Mills

Registered User.

Local time

Today, 01:59

Joined

Aug 29, 2002

Messages

871

• Jan 30, 2003

• #7

I'm guessing that Rich's code needs to be put in the On Open event of the pop-up form.

 

G

geno

Registered User.

Local time

Today, 06:59

Joined

Jun 19, 2000

Messages

243

• Jan 30, 2003

• #8

That's where I do have it, but nothing happens when the pop up form opens. The pop up form still has focus.

 

Oldsoftboss

AWF VIP

Local time

Today, 17:59

Joined

Oct 28, 2001

Messages

2,499

• Jan 31, 2003

• #9

How do you exit from the price info form. A button maybe, anyway, not important. I have found you have to progressivly set the focus

Forms![Orders].setfocus
Forms![Orders]![order details subform].setfocus
Forms![Orders]![order details subform]![unitprice].setfocus

HTH
Dave

 

R

Rob.Mills

Registered User.

Local time

Today, 01:59

Joined

Aug 29, 2002

Messages

871

• Jan 31, 2003

• #10

This is what I got to work:

Private Sub txtbox_Click()

DoCmd.OpenForm "Popupform"

Me.SetFocus

End Sub

This is the code to open the popup form.

If you need to set focus to a subform change to:

Me!SubformName.Form.SetFocus

 

G

geno

Registered User.

Local time

Today, 06:59

Joined

Jun 19, 2000

Messages

243

• Jan 31, 2003

• #11

Thanks Dave and Rob, I used Dave's suggestion first and at first it didn't work. I had it execute on the open event of the pop up form, I moved the code to the on exit of the first field, so when the user clicks the enter key the focus is set to the proper field I needed in the subform. Thanks again....