First of all sorry if this is in the wrong discussion section
I have a search form that displays a list of customers in a list box dependant on what i type into a text box.There is a query tied to the list box that gives a number sequence for each customer i.e 1 for the first line, 2 for the second and so on.
I then have another text box that i enter the number of the customer that i want and press enter which then opens another form with the customer details entered into the appropriate text boxes on the new form.
All this works great except that whatever number i enter into the text box the details on the next line of the sequence are copied and not the details from the line number i enter.
e.g. i enter 1 into the text box and the details on line 2 copy over to the next form.
any help would be much apprieciated
thanks
I have a search form that displays a list of customers in a list box dependant on what i type into a text box.There is a query tied to the list box that gives a number sequence for each customer i.e 1 for the first line, 2 for the second and so on.
I then have another text box that i enter the number of the customer that i want and press enter which then opens another form with the customer details entered into the appropriate text boxes on the new form.
All this works great except that whatever number i enter into the text box the details on the next line of the sequence are copied and not the details from the line number i enter.
e.g. i enter 1 into the text box and the details on line 2 copy over to the next form.
any help would be much apprieciated
thanks
