I'm a true novice please help me!!
I have a form that displays an ID number. I need a second form based on the same table, That uses the ID number from the first form as a link criteria to display information only on the subject that has that ID number. I know how to create the forms, I just need help on the linking technique. Thank you so much for any help.

depends what you put the id into. If it's a text box, write this code in form2

din id as string

id = form1.text1.text

now you can use the data

before you do that, it is better to put a public before the dim statement, so that it may become available for all subsequent procedures and functions.

I would say it is almost always better to not make variables public. Especially with a name as vague as "ID".

Tom

Please try this solution... i think that this will surely work ....
u declare the Id not in the form but in one module and when ever you are scnning the id u can say Id.text=module.id ....now u can call this value anywhere in any where by saying module1.id .....inm the second form u can say that diaplay where id=module1.id...
in the general sections of module1 declare it as PUBLIC ID AS STRING...
bye thankyou

(If you have multiple modules / functions / subroutines / etc, then pass the data you need between them by either value or reference. This way you do not get confused when you build bigger projects with many variables. This way you can call functions from as many places as you like without worrying about whether you wanted a variable to stay constant. This way if someone else has to support your code, they will only have to look locally for variable names rather than hunting through pages of code. This way, you keep a much tighter reign on the variables you create. This way you have a clear picture of the scope of the variable you have created and so can understand its function much better. This way you can reuse variable names - such as "ID" - in as many functions as you like and since they only have local scope they will not be overwriting eachother. This way you will learn that the use of global variables, at a basic level of programming, is for short-cuts and quick fixes only: If you rely on them, they will soon get well out of hand.)

This is a message board for multiple opinion. Mine is: LEARN HOW TO PASS VARIABLES BETWEEN FUNCTIONS AND ROUTINES. Its really useful. Honestly. Promise.

But do whatever makes you happy. It really makes no difference to me.

Tom

Hi guys,

Don, put the id number in a public variable.
Declare the variable in a module as public, then use the if statement from form2 to get the information.
If Form1.textbox.text="12345" Then
Form2.textbox.text=whatever
Just to give you an idea.

Hi guys,

Don, put the id number in a public variable.
Declare the variable in a module as public, then use the if statement from form2 to get the information.
If Form1.textbox.text="12345" Then
Form2.textbox.text=whatever
Just to give you an idea.
remember 12345 is pulled from the public variable.