Dlookup help

[Gazza2]

Im having a strange problem with my dlookup.

heres the code:-
Me.description = DLookup("[description]", "table2", "[partno] = '" & Me.PartNo & "'")

basically this is in the afterupdate of the partNo text box and when i enter a part no it brings up the description of the first record only no matter what part no i enter.Can anyone see a problem with the code.

 

[RuralGuy]

Your PartNumber is a Text field, right?

 

[Gazza2]

yes it is a text field

 

[RuralGuy]

I think it should work though having Table2 as part of your MainForm query would eliminate the DLookup() requirement.

 

[Gazza2]

the problem is that if i use a query then it shows all the records from the table in the subform and i dont want that.I want to be able to enter a part no and bring up the details in the other text boxes and then move to the next line.

 

[RuralGuy]

Any chance you can post your db with any sensitive data removed but with enough sample data to demonstrate the problem?

 

[Gazza2]

its form4 thats the problem.

 

[RV]

Your code is incorrect.
You're referring to a non-existing column partno whereas your column is named Part No

Change your code into

Me.description = DLookup("[description]", "table2", "[Part No] = '" & Me.PartNo & "'")

RV

 

[Gazza2]

it works

thanks rv it works a treat

 

[Gazza2]

ok now that works the next major headache im having is i cant add more than one line for some reason.

If i enter a part no into the text box it fills in all the details and goes to the quantity text box and after i enter a quantity it wont go to the next line it just returns to the part no text box on the same line.

The subform is set to continuous andit shows a blank record underneath the first line but i cant get it to go there.

Can someone point me in the right direction as no-one else seems to have this problem after reading the thousands of posts on here.

Thanks.

 

[pbaldy]

Check the Cycle property of the subform.

 

[Gazza2]

the cycle property is set to all records but i have tried it with current record and current page but it makes no difference.