Desperate autofill help

[Gazza2]

Ok here goes

I need some help with getting my form(form 2) to autofill from another form(form 1).

Now i dont want to use combo boxes or command buttons as i only want to use the keyboard and not the mouse.

Basically when a customer phones up to get prices they tell me there account code( this is in the customer details table) and i enter it into a text box on form 1 and after pressing enter it opens up form 2(this bit i can do) but i cant get it to open the form and display the correct details from the table on the form.

p.s why is it access books tell you everything except what you want to know.

thanks.

 

[RuralGuy]

You can use the OpenArgs argument of the OpenForm command or the Forms collection depending on the version os Access you are using.

 

[Gazza2]

nearly there

Ok problem solved sort of.

I can now open up the second form with all the details i need but i only want to do this if the full customer id is entered.

If someone enters the first few letters of a customer id can i have a subform appear on Form1 with the customers matching that part of the customer id.I have tried using a search form which i got from this forum but it isnt quite what i need as it opens another form.I want the subform to be hidden and only display if part of the customer id is entered.

Also i`d like to know if the list of customers on the subform can have numbers next to them so i can select which one i want from a text box and then open up form2 with the details.

I am using access 2002