Connecting Tech Pros Worldwide Help | Site Map

Interaction b/w tables and forms

 
LinkBack Thread Tools Search this Thread
  #1  
Old July 17th, 2006, 08:35 PM
erick-flores
Guest
 
Posts: n/a
Default Interaction b/w tables and forms

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, 03:35 AM
pietlinden@hotmail.com
Guest
 
Posts: n/a
Default 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, 03:05 PM
erick-flores
Guest
 
Posts: n/a
Default 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, 03:10 PM
Newbie
 
Join Date: Jul 2006
Posts: 2
Default

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.
 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,840 network members.