Open form at specific record from switchboard

  • Thread starter Thread starter duketter
  • Start date Start date
D

duketter

Access 2007 - I am trying to create a switchboard command button that allows
me to open up a form to a specific record(s). Is this doable? I have a
button that allows a user to edit previously entered information in the form.
However, since there can be many records, I would like to narrow it down to
only show the records for the specific company records they are looking to
edit. Is there a way to bring up a dialogue box, after the user clicks the
switchboard button to edit, that asks the user which company they want to see
the records for and then they just go directly to that companies records
instead of having to go through each one?

Thanks!
 
An even simpler solution may be to put an unbound combo box
in the header of your Company form so the users could quickly select the
appropriate company. The combo box would, for example, have the
following properties;

Rox Source = Select CompanyID, CompanyName From tblCompanies
Order By tblCompanies.CompanyName

Bound Column = 1
Column Count = 2
Column Widths = 0",2"

Then in the After Update event of the combo box you put the following code;

Private Sub cboCompanySearch_AfterUpdate

With Me.RecordsetClone
.FindFirst "CompanyID=" & Me.cboCompanySearch
If Not .NoMatch Then Me.Bookmark = .Bookmark
End With

End Sub
 
Back
Top