Input ID Number to Pull Record in Subform

[Elvis72]

I have done this before...its just been like 5 years.

I have a main form that gives project information.

Then I have a subform that shows the workers that are assigned to that project.

I want to input the worker id and have the rest of the fields populated from the original resume table.

Not clear on how to do this.

Let me know what else you need!~

Thanks!~

 

[PHV]

You may consider the DLookUp function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya Elvis72 . . .

. . . or you could use a recordset:

[blue]   Dim db As DAO.Database, rst As DAO.Recordset
   Dim SQL As String, Cri As String
   
   Set db = CurrentDb
   SQL = "SELECT * " & _
         "FROM TableName " & _
         "WHERE [IDname] = " & Me![idName]
   Set rst = db.OpenRecordset(SQL, dbOpenDynaset)
   
   Me![[purple][b][i]Name1[/i][/b][/purple]] = rst![[purple][b][i]Name1[/i][/b][/purple]]
   Me![[purple][b][i]Name2[/i][/b][/purple]] = rst![[purple][b][i]Name2[/i][/b][/purple]]
   '
   Me![[purple][b][i]NameN[/i][/b][/purple]] = rst![[purple][b][i]NameN[/i][/b][/purple]]
   
   Set rst = Nothing
   Set db = Nothing[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[Elvis72]

OK...trying the Dlookup at the moment and I have this:

DLookup("[First Name]", "[Last Name]", "[Worker ID] = Forms![ Plant Services Edit Entry form Staff Query]![Worker ID]")

BUT it is giving me a #Error Message?

Thanks!~

 

[Elvis72]

Getting a circular reference for control source message???

 

[Elvis72]

Well fixed that but still getting the #error message...??

 

[tennisguy]

Where you have [Last Name], shouldn't that be where you put the name of the table that [First Name] is located in? Do a separate DLookup for First Name and for Last Name in your subform.