Opening new form from within another form

[Gazza2]

I have a form which i use for data entry(Form1), i also have another form(form2) i would like to open and be autofilled with the details from a table(table1) when i enter a customer id into a text box on form1.

I need the code for this and also which event procedure to enter it into.

 

[Gazza2]

unsolved

I have tried using the form wizard to solve my problem but i dont get the screen that asks about a subform or linked form.

both forms will use data from the same table(Table1), the first form(form1)will have a customer name text box and when a customers name is entered into a text box i would like another form to open(form2) with the customers details(name,address etc) on it and also minimize the first form.

thanks for any help.

 

[Gazza2]

I`ve read about the where statement in help but cant make any sense of it atall.(maybe me being thick).

the other problem is that im not using a button to open the second form, when i get to the text box for the customer id and type in a customer id and press enter i would first like form2to open displaying all fields from my customer details table(i.e name,address etc)including the customer id that i typed into form1.

Sorry for being a pain and thanks for the help.

 

[Gazza2]

Although i understand that it would be easier to use a command button, i asked all my users what they would like and nearly all of them wanted(because they found it easier) to use the keyboard all the time.

Basically i have a form for entering customer orders(form1)when they get to the customer id text box and type in the customers id(primary key for customer details table)then another form customer details(form2) will open with the customers name,address etc autofilled. there will also be a few text boxes on form2 to enter a different delivery address if needed.

thanks