Dlookup or Join Advice on Forms

[ilikebirds]

I was wondering what method would be more appropriate for the following scenario.

I have a form that allows a user to enter 1001 into a text box.
Once enter is hit, would it be better to use a Dlookup to Switch that 1001 into it's corresponding value on another table... Or use a Join.

Thanks

[NeoPa]

You have (accidentally) posted this question in the Access Articles section. This is NOT an article.
I'm moving this to the main Access questions forum.

ADMIN.

[NeoPa]

I was wondering what method would be more appropriate for the following scenario.

I have a form that allows a user to enter 1001 into a text box.
Once enter is hit, would it be better to use a Dlookup to Switch that 1001 into it's corresponding value on another table... Or use a Join.

Thanks

Do you even want a TextBox?
If you're looking for a value from a table surely a ComboBox would be a better method?

For more help you NEED to post some information.

[ilikebirds]

Do you even want a TextBox?
If you're looking for a value from a table surely a ComboBox would be a better method?

For more help you NEED to post some information.

Sorry About accidently posting it in the Article Section.


What I currently have is:
Me!error_value = DLookup("[error_value]", "[errors]", "error_id='" & Me!error_id & "'")

in the After Update event procedure of the error_id field.

So once someone scans in a number - the error value field is autoupdated.

This fixed my problem pretty much. I also removed the Tab Stop from the Err0r_value field.

Thanks again

[NeoPa]

No worries. And thanks for sharing your solution.
I still feel a ComboBox with all the valid values in it would make more sense for this, but your solution certainly does the trick too (so why change huh).