create a find control that will find a record and fill in the nee.

[Guest]

create a find control that will find a record then fill in the specific files
in a form

 

[Guest]

Hi Joe

Provideing that you have made your form right you should be able to just "go
to" the record and the fields will autofill.

Create an unbound combo (call it Find Record) and place this behind the
AfterUpdate

Private Sub FindRecord_AfterUpdate()
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[IDField] = " & Str(Me![FindRecord])
Me.Bookmark = rs.Bookmark
End Sub

This will located the unique IDfield (primary) and go to that record.

Hope this helps

 

[John Vinson]

create a find control that will find a record then fill in the specific files
in a form

Forms don't contain "files".

Could you explain what you are trying to accomplish, and describe your
current database structure? What do you want to "fill in", and where
will the contents come from?

John W. Vinson[MVP]