By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,501 Members | 2,681 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,501 IT Pros & Developers. It's quick & easy.

Interaction b/w tables and forms

P: 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

Jul 17 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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]

Jul 18 '06 #2

P: n/a
Thank for answering. Maybe I am doing something wrong

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

Jul 18 '06 #3

P: 2
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.
Jul 18 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.