Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Moving from Subform to Subform


Message #1 by "Christopher Oberheim" <choberheim@l...> on Thu, 19 Jul 2001 13:31:44
I have multiple subforms and still can not figure out how to get from the 

last cell in the first subform to the first cell in the next subform. I am 

VBA illiterate. 



Thanks

Chris
Message #2 by "Pardee, Roy E" <roy.e.pardee@l...> on Thu, 19 Jul 2001 07:53:26 -0700
I'm afraid that without VBA (or requiring your users to hit ctl-tab when

they want out of the first subform) there isn't any good solution to the

problem you pose (or I can't think of one anyway).



Sorry I can't be more helpful...



-Roy



-----Original Message-----

From: Christopher Oberheim [mailto:choberheim@l...]

Sent: Thursday, July 19, 2001 6:31 AM

To: Access

Subject: [access] Moving from Subform to Subform





I have multiple subforms and still can not figure out how to get from the 

last cell in the first subform to the first cell in the next subform. I am 

VBA illiterate. 



Thanks

Chris



Message #3 by "wilfred van casteren" <vancasterenw@a...> on Thu, 19 Jul 2001 19:14:28
I had this problem once long ago.

When i clicked tab, the cursor didn't go where i wanted it to go.

Open your form in design mode , change the tab property (i have a dutch 

version.)in the tab page named other.





> I have multiple subforms and still can not figure out how to get from 

the 

> last cell in the first subform to the first cell in the next subform. I 

am 

> VBA illiterate. 

> 

> Thanks

> Chris
Message #4 by "wilfred van casteren" <vancasterenw@a...> on Thu, 19 Jul 2001 20:13:09
I had this problem once long ago.

 When i clicked tab, the cursor didn't go where i wanted it to go.

 Open your form in design mode  get to the properties, change the tab 

property (i have a dutch 

 version.)in the tab page named other.

 

 

> I have multiple subforms and still can not figure out how to get from 

> the 

> > last cell in the first subform to the first cell in the next subform. 

I 

> am 

> > VBA illiterate. 

> > 

> > Thanks

> > Chris
Message #5 by "Peter Kaufman" <kaufman@l...> on Fri, 20 Jul 2001 19:37:51 +0700
I think you need VBA (I don't do macros so can't be sure if it can be done

with one or not). You need to code the move on the lost focus event of the

last cell in the first subform, but in my experience this is just too cute

and does not work well in the real world. Subforms are a real PITA in many

ways in Access....



HTH,



Peter



> -----Original Message-----

> From: Christopher Oberheim [mailto:choberheim@l...]

> Sent: Thursday, July 19, 2001 1:32 PM

> To: Access

> Subject: [access] Moving from Subform to Subform

>

>

> I have multiple subforms and still can not figure out how to get from the

> last cell in the first subform to the first cell in the next

> subform. I am

> VBA illiterate.

>

> Thanks

> Chris

> ---



>




  Return to Index