Matching a value from one form to another

[erick-flores]

Hello all,
Here is what i am trying to do doing:
Form A & Form B
Form A:
compressor_id = 23
Description: test

Form B:
stage_id = 12
compressor_fk = compressor_id
Description: test2

I create a button in Form A so when I click it it will take me to Form
B. I have the relationship b/w my tables, where COMPRESSOR (name of
table) compressor_id = compressor_fk in the STAGES table. That is
working fine. Now what I want is: when I click on the button that takes
me to Form B, it will automatically display my compressor_id into the
compressor_fk. Right now, I can type the compressor_id into my Form B
and it will recognize it w/o any problem. I tested by going to the
tables and I can see the values are matching (compressor_id and
compressor_fk).
Summary: I want it to automatically display the compressor_id in my
Form B, I do not want to type it.

Please help, thank you

[Bob Quintal]

"erick-flores" <ch**********@hotmail.comwrote in
news:11**********************@h48g2000cwc.googlegr oups.com:

Hello all,
Here is what i am trying to do doing:
Form A & Form B
Form A:
compressor_id = 23
Description: test

Form B:
stage_id = 12
compressor_fk = compressor_id
Description: test2

I create a button in Form A so when I click it it will take me
to Form B. I have the relationship b/w my tables, where
COMPRESSOR (name of table) compressor_id = compressor_fk in
the STAGES table. That is working fine. Now what I want is:
when I click on the button that takes me to Form B, it will
automatically display my compressor_id into the compressor_fk.
Right now, I can type the compressor_id into my Form B and it
will recognize it w/o any problem. I tested by going to the
tables and I can see the values are matching (compressor_id
and compressor_fk).
Summary: I want it to automatically display the compressor_id
in my Form B, I do not want to type it.

Please help, thank you

In the OnClick Event on form A you need to add a command which
copies the value of the control on form A to the equivalent
Control on form B, after the command that opens form B.

Forms!form_B!compressor_fk = me.compressor_id
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[erick-flores]

Thank for your answer

I did what you told me but I am getting an error message:

Private Sub Command22_Click()
On Error GoTo Err_Command22_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "STAGES"
DoCmd.OpenForm stDocName ', , , stLinkCriteria
forms!Stages!comp_fk = Me.comp_pk

Exit_Command22_Click:
Exit Sub

Err_Command22_Click:
MsgBox Err.Description
Resume Exit_Command22_Click

End Sub

The line "forms!Stages!comp_fk = Me.comp_pk"
----!Stages <---- it higlight this, and says:
Compile error:
Qualifier must be collection

Stages is the name of my Form B

Any suggestions? I am going crazy with this if you can help I will
really aprecciate

Thanks

[erick-flores]

I am also trying:

Private Sub Command22_Click()
On Error GoTo Err_Command22_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "STAGES"

stLinkCriteria = "[comp_fk]=" & Me![comp_pk]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Command22_Click:
Exit Sub

Err_Command22_Click:
MsgBox Err.Description
Resume Exit_Command22_Click

End Sub

This is working fine, it just wont display the value from the Form A to
the Form B. Is there an option to display the value from the Form A to
Form B? because the "[comp_fk]=" & Me![comp_pk] its working but its not
displaying the value. I wanna see my value displayed from form A to
form B.

Please helppp :'(

[pietlinden]

This is working fine, it just wont display the value from the Form A to
the Form B. Is there an option to display the value from the Form A to
Form B? because the "[comp_fk]=" & Me![comp_pk] its working but its not
displaying the value. I wanna see my value displayed from form A to
form B.

Please helppp :'(

If you're trying to _copy_ the value, then you have to set it

Forms![MyFormB]![ControlName]=Forms![MyOpenFormA]![ControlName]

[Bob Quintal]

"erick-flores" <ch**********@hotmail.comwrote in
news:11**********************@35g2000cwc.googlegro ups.com:

Thank for your answer

I did what you told me but I am getting an error message:

stDocName = "STAGES"
DoCmd.OpenForm stDocName ', , , stLinkCriteria
forms!Stages!comp_fk = Me.comp_pk

The line "forms!Stages!comp_fk = Me.comp_pk"
----!Stages <---- it higlight this, and says:
Compile error:
Qualifier must be collection

Stages is the name of my Form B

comp_fk is the name of the control on that form, which may be
different from the field name in the table?
same question about comp_pk.

It may also be a timing issue, the form may not open quickly
enough. Try a doevents statement between the Docmd.Openform line
and the one which sets the variable.

See also mr Linden's notes about [] around the elements in the
expression. They are necessary only with spaces and punctuation
in element names, but it doesn't hurt to include them.

since the code is in form A, me. should work, as a reference to
the form, but you can go with the long notation too..

>
Any suggestions? I am going crazy with this if you can help I
will really aprecciate

Thanks

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[erick-flores]

Hello

Thank you guys for helping me. I finally figured out.

[erick-flores]

OK, So I am getting another problem. I dont know whats happend with
this, but sometimes it works sometimes it doesnt. Its driving me crazy,
but anyways. When I click the button to open Form B it is showing the
foreign key from my Form A BUT it its also automatically displaying the
primary ID of Form B. This primary key i set it up =Autonumber. This
was not happening before. Any suggestions'???

[Bob Quintal]

"erick-flores" <ch**********@hotmail.comwrote in
news:11**********************@75g2000cwc.googlegro ups.com:

OK, So I am getting another problem. I dont know whats happend
with this, but sometimes it works sometimes it doesnt. Its
driving me crazy, but anyways. When I click the button to open
Form B it is showing the foreign key from my Form A BUT it its
also automatically displaying the primary ID of Form B. This
primary key i set it up =Autonumber. This was not happening
before. Any suggestions'???

I can tell you why it is happening now and wasn't happening
before, and you can decide whether to handle it.

Before, when you opened form B, the autonumber did not appear
UNTIL you typed something in any textbox on the form.

Because you have some code that types something into one of the
textboxes, it makes the autonumber appear as soon as you open
the form.

why are you displaying the ID on the form anyways? It is not
reccommended.

[erick-flores]

Hello Bob

That was not the real problem, I didnt explain very well in the last
reply. The problem is: It will display the SAME primary key in Form B
everytime I click on the button to go from Form A to Form B. So
obviusly it is changing the same record all the time I switch to Form
B. i do not knwo why this is happend, because the option to that
primary key is Autonumber, so it supposed to display a different number
everytime the form opens, or not? maybe I am doing something wrong. I
tried both Autonumber (increment, random) and I got the same
environment.

why are you displaying the ID on the form anyways? It is not
reccommended.

I am only displaying the ID to see if its working, just for
functionality issues. But I will remove the ID from the forms once I
know its working well, once all my forms are related through the pk and
fk. I guess I will just select the "hide = yes" option for that field.

Thanks

[erick-flores]

I found something interesting. The primary key in the Form B is
displaying the same one. If I go to the tables and manually add a new
record to the table that is attach to Form B the Autonumber will work
perfect, it will be incrementing. BUT when I go back and run the forms
it will display the same pk that it displayed the last time (will not
follow the autonumber from the those record that I add in the tables).
Dont know why this is happend.
I was thinking maybe in writing some code, in the clickevent, to set
the pk from Form B to a ramdon number everytime it opens, to eliminate
this problem. Do you know how to write this random code?

[erick-flores]

OK, I think I know where the problem is. When Form B opens it need to
automatically add a new record (set all the fields to blank[no data],
only the pk from Form B will be display), insted of looking at the ones
that I've already enter. Do you know how to do this?

[Bob Quintal]

"erick-flores" <ch**********@hotmail.comwrote in
news:11**********************@s13g2000cwa.googlegr oups.com:

OK, I think I know where the problem is. When Form B opens it
need to automatically add a new record (set all the fields to
blank[no data], only the pk from Form B will be display),
insted of looking at the ones that I've already enter. Do you
know how to do this?

Yes. There are two ways to do this. The first is to set the
..dataentry property to Yes in the form's design view and save it.

The second way is to tell the form to open on a new record, this is
a parameter of the docmd.openform
docmd.OpenForm "Form2",,,,acFormAdd

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com