Passing parameters to forms

[rsfnoam]

Hi everyone
First of all I would like to thank RODMC for the advice about that bugging problem with displaying data in datasheet view..thanks very much again.
I got a problem with passing parameters to forms.
The situation is:I have 9 or ten forms with two data fields changing all the time.
The forms are named: answer_form1...ans_form10
the the data table doesn't change.
the columns changing: in answer_form1 = quest2res1
in answer_form2= quest2res2 and so forth..
I want to create a main form and pass the form name and the columns in parameters so that the form will open in the right mode by the user's selection
Can someone help in that or is there an example that I can study that?
Thanx alot in advance
Noam

 

[John Big Booty]

You can pass information between forms using the OpenArgs portion of the OpenForm method.

That having been said, your table structure does not sound normalised, it may pay to read up on this concept and perhaps rethink your table structure, this may well simplify what you are currently trying to achieve.

 

[rsfnoam]

Hi john
Gee thanx for that quick respose..
Why do you say that it is not normalized.? To think it up is always a helpful advice I'll be happy to..
Well I need to keep 10-30 in parallel i.e. I need a column for each result in the same data record .everyone of those columns is a combo which after the user enters the appropriate answer it opens the appropriate answer as well..so I have to keep some column for column answers somehow..What i did is creating a main form that points to the appropriate data entry form and that form is driven by the user's choice. If you have an idea how to keep 10-30 needed columns in parallel I'll be happy to learn from your advice..
Noam

 

[John Big Booty]

The comment on normalisation, was a guess based on your description, in your OP.

You could compare your current table structure with one of the data models found here and see how it stacks up.

 

[rsfnoam]

Wow.. Thanx
That is very vey helpfull
Noam

 

[rsfnoam]

Hi John
I looked at that site and found out that I got nearly the same structure diagrams ideas(i.e. ideas not same tables and same tables (-
As for that. How do I use the docmd.open form with the open args
What I know (I know that what i don't know is alot more ha) is that the openargs is where I pass the arguments..
for example I want to open the answer_form1 and pass the quest2res1 and quest2res12 .
What i have now is an answer form: ans_form1 and there quest2res1list(combo bound to quest2res1)
and quest2res12list (combo bound tquest2res12)
I created
quest2res1(the database column) goes to a combo field:
I created a format form. but how do I bind the the quest1list and quest12list to the passed argumnets..I guess 1 or 2 examples will allow me to continue
Thanx alot in advance
Noam

 

[John Big Booty]

This post should give you some pointers.

 

[rsfnoam]

Hi john
Many many Thanx
Noam