473,407 Members | 2,629 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,407 software developers and data experts.

variable question

How do I get a number in a field from one form to another?
Form1 has a record with a Long Integer field (call it TagNum). I need
to get the number from TagNum saved into memory somehow, as a variable I
am guessing. The record is copied to another table with an append
query, and then the record is then deleted from the first table. A new
form is opened and I want to be able to open the record that was just
copied into Form2. I am trying to get the TagNum to be used as a filter
in the 2nd form so it only shows that one record in the form.

I hope I havn't confused everyone, but I would appreciate any and all
help with this.
Thanks,
Ray
Nov 13 '05 #1
2 1129
Basically what I am asking is how to make a variable based on a control
static instead of dynamic, and not lose the value in the variable when
the control is reset or cleared.
Thanks.

Ray Holtz wrote:
How do I get a number in a field from one form to another?
Form1 has a record with a Long Integer field (call it TagNum). I need
to get the number from TagNum saved into memory somehow, as a variable I
am guessing. The record is copied to another table with an append
query, and then the record is then deleted from the first table. A new
form is opened and I want to be able to open the record that was just
copied into Form2. I am trying to get the TagNum to be used as a filter
in the 2nd form so it only shows that one record in the form.

I hope I havn't confused everyone, but I would appreciate any and all
help with this.
Thanks,
Ray

Nov 13 '05 #2

"Ray Holtz" <ra*@rayholtz.com> wrote in message
news:d4**********@schooner.siu.edu...
How do I get a number in a field from one form to another?
Form1 has a record with a Long Integer field (call it TagNum). I need to
get the number from TagNum saved into memory somehow, as a variable I am
guessing. The record is copied to another table with an append query, and
then the record is then deleted from the first table. A new form is
opened and I want to be able to open the record that was just copied into
Form2. I am trying to get the TagNum to be used as a filter in the 2nd
form so it only shows that one record in the form.

I hope I havn't confused everyone, but I would appreciate any and all help
with this.
Thanks,
Ray

Create a procedure in Form1 that:
1. Writes TagNum to an Long-type variable (MyVariable)
2. Runs the append query
3. Runs the delete query
4. Opens Form2 using the OpenForm Method and the optional WhereCondition
(TagNum = MyVariable)
5. Closes Form1


Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

44
by: Mohanasundaram | last post by:
int i = 10; int main() { int i = 20; return 0; } Hi All, I want to access the global variable i inside the main. Is there
4
by: Gery D. Dorazio | last post by:
Gurus, If a static variable is defined in a class what is the scope of the variable resolved to for it to remain 'static'? For instance, lets say I create a class library assembly that is...
23
by: Russ Chinoy | last post by:
Hi, This may be a totally newbie question, but I'm stumped. If I have a function such as: function DoSomething(strVarName) { ..... }
3
by: James Robertson | last post by:
I am new to the ASP and VB thing so be kind. Question I have is that I have created an ASPX web site to use as an E-Mail page. But I want to use this for a lot of users. Can I create the link on...
29
by: garyusenet | last post by:
I'm trying to investigate the maximum size of different variable types. I'm using INT as my starting variable for exploration. I know that the maximum number that the int variable can take is:...
53
by: fdmfdmfdm | last post by:
This is an interview question and I gave out my answer here, could you please check for me? Q. What are the memory allocation for static variable in a function, an automatic variable and global...
37
by: minkoo.seo | last post by:
Hi. I've got a question on the differences and how to define static and class variables. AFAIK, class methods are the ones which receives the class itself as an argument, while static methods...
5
by: somenath | last post by:
Hi All , I have one question regarding scope and lifetime of variable. #include <stdio.h> int main(int argc, char *argv) { int *intp = NULL; char *sptr = NULL;
19
by: Hapa | last post by:
Does only reading (never writing) of a variable need thread synchronisation? Thanks for help? PS. Anybody knows a Visual C++ news group?
112
by: istillshine | last post by:
When I control if I print messages, I usually use a global variable "int silent". When I set "-silent" flag in my command line parameters, I set silent = 1 in my main.c. I have many functions...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.