Copy value from subform1 to subform two when all are open

[colleen1980]

There are two continuous subforms in main form. All are linked with
ticketNum. When user comes to subform2. I need that Field3 of subform2
will automatically filled with field2 (field2 is a textbox) of
subform1. Field3 is a listbox where i need that user has to select
single or multiple values. control which i am using is a listbox in
field3. How to i do that needs help.

Thanks.

[Arno R]

It's not very clear to me what you want.

You say you need code when subform2 is entered?? ("user comes to subform2")
So you want all Fields3 of all teh records on subform2 to have the value of the current record in subform1 ??

Or you need code for a certain record when a certain (new or existing ??) record in subform 2 is getting the focus ??
Please explain again what you need.

Arno R

<co*********@gmail.comschreef in bericht news:11**********************@i42g2000cwa.googlegr oups.com...

There are two continuous subforms in main form. All are linked with
ticketNum. When user comes to subform2. I need that Field3 of subform2
will automatically filled with field2 (field2 is a textbox) of
subform1. Field3 is a listbox where i need that user has to select
single or multiple values. control which i am using is a listbox in
field3. How to i do that needs help.

Thanks.

[colleen1980]

Thanks for your reply. Subform2 is a continous form. One of the subform
field name Field3. Field3 is a type text . Since subform2 is a
continous form so the value can be one or more then one. But all forms
are connected with a field name TicketNum. After entering the values in
Subform2 user has an option to enter values in subform3. If user wants
to enter values in subform3 she select an option from the drop down
which is the part of subform2. Once she select an option from drop down
the subform3 is open.

Here in subform3 once it opens there is a listbox name Field2. I need
help here. I need to move values from subform2.field3 into list box
name subform3.field2.

Arno R wrote:

It's not very clear to me what you want.

You say you need code when subform2 is entered?? ("user comes to subform2")
So you want all Fields3 of all teh records on subform2 to have the value of the current record in subform1 ??

Or you need code for a certain record when a certain (new or existing ??) record in subform 2 is getting the focus ??
Please explain again what you need.

Arno R

<co*********@gmail.comschreef in bericht news:11**********************@i42g2000cwa.googlegr oups.com...

There are two continuous subforms in main form. All are linked with
ticketNum. When user comes to subform2. I need that Field3 of subform2
will automatically filled with field2 (field2 is a textbox) of
subform1. Field3 is a listbox where i need that user has to select
single or multiple values. control which i am using is a listbox in
field3. How to i do that needs help.

Thanks.

[Arno R]

<co*********@gmail.comschreef in bericht news:11*********************@m7g2000cwm.googlegrou ps.com...

Thanks for your reply. Subform2 is a continous form. One of the subform
field name Field3. Field3 is a type text . Since subform2 is a
continous form so the value can be one or more then one. But all forms
are connected with a field name TicketNum. After entering the values in
Subform2 user has an option to enter values in subform3. If user wants
to enter values in subform3 she select an option from the drop down
which is the part of subform2. Once she select an option from drop down
the subform3 is open.

Here in subform3 once it opens there is a listbox name Field2. I need
help here. I need to move values from subform2.field3 into list box
name subform3.field2.

Arno R wrote:

>It's not very clear to me what you want.

You say you need code when subform2 is entered?? ("user comes to subform2")
So you want all Fields3 of all teh records on subform2 to have the value of the current record in subform1 ??

Or you need code for a certain record when a certain (new or existing ??) record in subform 2 is getting the focus ??
Please explain again what you need.

Arno R

<co*********@gmail.comschreef in bericht news:11**********************@i42g2000cwa.googlegr oups.com...

There are two continuous subforms in main form. All are linked with
ticketNum. When user comes to subform2. I need that Field3 of subform2
will automatically filled with field2 (field2 is a textbox) of
subform1. Field3 is a listbox where i need that user has to select
single or multiple values. control which i am using is a listbox in
field3. How to i do that needs help.

Thanks.

*IF* I understand you now (I am not sure ...) you want to fill a listbox (Field2) with the values of Field3 of subform2 ??
Actually you are asking a question about the rowsource isn't it ??
Create a query or sql-string for the rowsource of field2, which will be Field3 of the recordsource you are using for subform2.
When a user enters the listbox on subform3 use code like Me!Listbox.requery.

Is this what you need ??

Arno R