Cheeky Help Please

[Gazza2]

I have added a copy of my database in the hope that someone can answer my questions.

1. On form4 i can get it to open from form3 displaying the info for the customer and go straight to the part no text box (that part is fine), What i need is for the subform to be empty and when i enter a part no it displays in the list and i can keep entering part no`s and adding them to the list.

2.On form3 if i only enter part of the customer id then i need the hidden subform to display the matching criteria, i.e. if i enter cus1 it will open the hidden subform displaying cus10 and cus12 but if i enter cus 10 then it will just open form4.

Any help will be much appreciated and thanks in advance.

 

[le888]

Is this what you want?

Le888

 

[Gazza2]

almost

that is almost what i want.

basically when i type in the name and it automatically opens the form is better than i wanted but the subform needs to be hidden and when i type in part of the name and press ENTER then the subform will unhide and display the names matching the part name i typed in.

Thanks very much indeed for the help.

 

[le888]

check this...

Le

 

[Gazza2]

thanks

absolutely perfect thanks very much for all your help.

 

[Gazza2]

next problem

ok the first part works great but the next part is doing my head in.

when i have entered the customer id and the next form(form4) has opened with the cursor in the part no text box how do i get the part no`s i enter into the text box display in the subform.

 

[le888]

First, you have to relate the table 1 with table 2. Second, in form4, you have to change the control source of the text box "enter no part" to "part no".

Le

 

[Gazza2]

feeling a bit simple

relative info(i think)

table 2
part no
bin no
description
retail
discount

subform 2

form header
text box(unbound)

main part of form
all fields in table 2 as datasheet view

when i enter a part no into the unbound text box i want the other text boxes to autofill with the details from table2 and then move to the next line so i can enter another part no and so on.

i`m not sure if i need to create a query, write code or just throw the computer out the window.

at some point i may need to print the details but that can wait.

 

[le888]

Try this...