Connecting Tech Pros Worldwide Help | Site Map

Interaction b/w tables and forms

  #1  
Old July 17th, 2006, 09:35 PM
erick-flores
Guest
 
Posts: n/a
Hello all, I have multiple tables. They all are related by foreign
keys. What I am trying to create different forms that will interact
with my tables. My plan is to design a form, I will enter the
information and then click on a button that will take me to my next
form. This next form should already have the ID of my other form, so I
will enter the information that I need for that one and so on. I
already have the tables, I tried creating one form, put the button,
this button will open my next form BUT the information from my previous
form is not in there. When I go and check my table the information is
there. So I really do not how to make this relationship...the
relationship b/w my tables looks good

This is an example of what I am trying to do:

Form A

Class_id: (AutoNumber) ---->this will create an automatic ID so lets
say its = 23
Tag#: 2390429034
Bus Team: test
Service: test2

Then I click on the button that says "Form B"

Form B
Item id_: (AutoNumber) -----same procedure
Class_id: 23
Description: test3
..
..

So this is What I want. My Class_id to be display in the next form, so
everything is in a relationship

Please help me

Thank you

  #2  
Old July 18th, 2006, 04:35 AM
pietlinden@hotmail.com
Guest
 
Posts: n/a

re: Interaction b/w tables and forms


Subforms don't work?

Otherwise, you need to set the FK value in the code that opens the
child form.

DoCmd.OpenForm "Myform"
Forms![MyForm]![ForeignKey]=Forms![ParentForm]![PrimaryKey]

  #3  
Old July 18th, 2006, 04:05 PM
erick-flores
Guest
 
Posts: n/a

re: Interaction b/w tables and forms


Thank for answering. Maybe I am doing something wrong

Can you tell me the way you will do this? the easiest way

  #4  
Old July 18th, 2006, 04:10 PM
Newbie
 
Join Date: Jul 2006
Posts: 2

re: Interaction b/w tables and forms


Hi. I found a way to do this, but you have to keep both forms open. Go onto the text box properties that you want to have the value automatically put into, then clcik on RowSource or something like that and enter the text box you want to get the data from.
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Try #2 - Inheritance work-around in VBA Steve Jorgensen answers 14 November 12th, 2005 10:49 PM
Try #2 - Inheritance work-around in VBA Steve Jorgensen answers 14 November 12th, 2005 10:22 PM
Commercially producing a product Corinne answers 6 November 12th, 2005 02:48 PM
how to layout forms with css Roderik answers 14 July 21st, 2005 12:35 AM