Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 24th, 2003, 12:47 PM
Authorized User
 
Join Date: Jun 2003
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default Passing variables

Hello everyone. I have some confusion on passing variables. I need to store variables from a form and then retrieve them later. What I have is three form that a user fills out and presses a next button to go to the next one. So the idea is to have the values from the text boxes stored and when the final form is finished retrieve all the variables for an SQL command.

Any ideas will be greatly appreciated.

Thanks,
Jesse
__________________
Thanks,
Jesse
 
Old October 24th, 2003, 12:59 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Why don't you just use a tab control to put all the info instead of jumping from one form to another?

Sal
 
Old October 24th, 2003, 01:08 PM
Authorized User
 
Join Date: Jun 2003
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default

That is how I had originally built it but it was requested that the fields be seperated in groups in seperate forms and to guide the users navigation with a next button. All of the fields from the seperate form need to be added to a single table at the final step.

Quote:
quote:Originally posted by sal
 Why don't you just use a tab control to put all the info instead of jumping from one form to another?

Sal
Thanks,
Jesse
 
Old October 24th, 2003, 01:29 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You can either create global variables in a module (I do not like those) or open a hidden form and set values on it as you go along.




Sal
 
Old October 24th, 2003, 01:45 PM
Authorized User
 
Join Date: Jun 2003
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks, I'll try that.

Thanks,
Jesse





Similar Threads
Thread Thread Starter Forum Replies Last Post
Passing Variables silve1999 Pro Java 1 June 15th, 2006 12:54 PM
Passing Variables CMOS Classic ASP Basics 2 January 22nd, 2006 07:38 PM
Passing variables karlirvin PHP How-To 4 December 2nd, 2005 08:02 PM
Passing variables acko ASP.NET 1.x and 2.0 Application Design 1 December 23rd, 2003 09:40 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.