Updating text box with information from auto populated field.

[Trams]

Hello all, this is my first time posting and looking for some help. I have a database that tracks productivity and a form where the team puts the data.

In order to make it easier for them I would like to automate the process. On the form I have an unbound text box that pulls in the computer name automatically using =GetMachineName(). The computer name is also part of a separate table that includes there name and ID.

I want the form to auto populate the Name and ID field when they open it based on this unbound field called "compname"

This may be simple but I am drawing a blank



Thanks

[June7]

So this form is already bound to a table/query? You want to save the ID to a field in this RecordSource?

You could use DLookup in the ControlSource of each textbox: DLookup("ID", "tablename", "compname='" & [machinename] & "'")

Then to save the ID will have to use code in some event, perhaps when the form closes: Me!ID = Me.ID

[Trams]

Thank you that worked perfectly.