Finding Field when entering ID

[ManuNeko]

I have a form where I want to enter an ID and then see the Name in the next field.
How do I do that? Everytime I enter an ID I get "?Name" in the next field.

The Table is "BudgetLine" and I enter an ID from a table "Item"

Item
ID
Name

 

[ColinEssex]

Post the code you're using

Col

 

[ManuNeko]

View attachment Budget.zip

I'm talking about the form "Budget" and the problem is in the SubForm "BudgetLine"

 

[ManuNeko]

I tried working with DLookUp, but than every record changes.

View attachment Budget.zip

 

[Pat Hartman]

I didn't look at your database but the solution is most likely that you need to base the form on a query that joins the two tables. That way you can see both the numeric "id" and the text "description". If you use this technique, be sure to set the control properties for all the columns from the lookup table to locked = yes and enabled = no. This will prevent accidental updates to the lookup data.

 

[ManuNeko]

I tried it and it works.

Thank you