Pull text from another table

[nigelbloomy]

I have a form which pulls information from an audit table. In the title of the form (in a field called TopLevel) I would like to show the top level part number where all of the auditing occurred. I have another table (the entry form table) which just has one record which contains the top level part number.
When I try to put the part number from the entry form table into the control source for the form title, it just returns an error in the field.
I tried writing the following code but it gives me an object error:

Private Sub Form_Load()
    Dim rsParent As DAO.Recordset
    
    Set rsParent = dbCurrent.OpenRecordset("Entry Form Table", dbOpenTable)
    Forms![Audit Form]![TopLevel] = rsParent!Part_Number
End Sub

I think I am making this more complicated than it needs to be.

[pbaldy]

dbCurrent should be CurrentDb. You could also use a DLookup, but what you have should work with that fix.

[pbaldy]

Oh, and don't forget

Set rsParent = Nothing

[nigelbloomy]

That works perfectly. I had copied the format from a place where the code defined a variable called dbCurrent as Currentdb. I didn't notice the switch.
I will add in the code to set it to nothing and close it as well.

Thank you for your help.

[pbaldy]

Happy to help.