Hi all,
I have a little problem.
There is a form which includes a subform with common field ID!
Each form has a Last Name such:
MAIN FORM:ID 411
          LAST NAME: Smith

SUB FORM:ID 411
          LAST NAME: Lee

Now I created a third form with a field which includes a list of all the names, from main and sub form!
I d like in this form (third form) when I'm selecting a Last Name to I'm push a button and open the main form even though the name I have selected is from the subform

Create 2 unbount text boxes on your third form and enter the follwoing lines in each

=Forms!Mainform![Last Name] ------- type in first uboubd box
=Forms!Mainform!Subform1.Form![Last Name] -----type in second unbound text box

Then create another unound text box and concatinate the above 2 textboxes.

This you may get thru the command button also

Ashfaque

Thank you very much for the advice Ashfaque but maybe I didn't understand!
Could you please tell me where exactly to write it each one!
Furthermore I'd like to inform you that I don't want text box but list box to select the last name (the last names, I think, I must take them as a query for each unbound box from its table/form.

The 2 unobound text boxes you should place on to your third form. And click into one of the them & write in it =Forms........ and simillarly for the second unbound text box also.

OR

Create a command button onto your third form and write following code on its OnClick event (Of Commmand Button). Now assume that your 2 new text box names are Text0 & Text1 and command button name is Command0. So code will be :

Private Sub Command0_OnClick()

Text0=Forms!Mainform![Last Name]
Text1==Forms!Mainform!Subform1.Form![Last Name]

End Sub

Once you click the command button, the data will be in to your 2 unbound text boxes. At last place another (Third) unbound text box and concatinate data of Text0 & Text1 into third unboud text box.

Like this:

=Text0 & " " & Text1

Please note that your Main form alongwith sub form must be open to get the data onto the third form.

Even if doesn't work, just drop me your 3 forms in a zip file along with your clear requirement. I will look into.

HTH
Ashfaque

give me your e-mail

[email protected]