How to link to Database linked forms ? 
Author Message
 How to link to Database linked forms ?

Hello every body,

I'm beginning with VB 5.0.
Can someone tell me how to for this:
- I have form1 linked with a database
- I have a button in form1 which load form2 (linked with the same Database)
How to do to open form2 on the same recordset that the one in form1 (there
is the same IDKey in the two forms).

Thank you very much for helping.

Ridha



Sun, 06 May 2001 03:00:00 GMT  
 How to link to Database linked forms ?
Ridha,
    If you pass the IDKey from form1 to form2, then in your form2 load do a
query on your dataset for that IDKey.  For example, on form1 I am looking at
IDKey of 8 out of 16.  I assign a public variable IDKeyVar = 8.  When I open
Form2 I do a query where Table.IDKey = form1.IDKeyVar.  This should work.

my page at www.geocities.com/SiliconValley/Park/1904

Tim Reed

Quote:

>Hello every body,

>I'm beginning with VB 5.0.
>Can someone tell me how to for this:
>- I have form1 linked with a database
>- I have a button in form1 which load form2 (linked with the same Database)
>How to do to open form2 on the same recordset that the one in form1 (there
>is the same IDKey in the two forms).

>Thank you very much for helping.

>Ridha



Sun, 06 May 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Linking an access database search form to the Internet

2. Word form link to Access Database

3. Accessing Multiple Linked Database Tables on the VB Form

4. NEWBIE NEEDS HELP WITH DATABASES AND LINKING FORMS

5. Linking a form to a database in VisualBasic

6. linking text boxes on different forms to same database

7. How do you link the ADO Chart and database forms

8. HELP-Link 2 forms to one database

9. Changing the linked table path without the linked table manager

10. Delete link and recreate link automatically

11. Excel Linking and Excel/Access Linking

12. linking all fields in linked table?

 

 
Powered by phpBB® Forum Software