Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Open a blank form and find a particular record

Status
Not open for further replies.

Bevo48

Technical User
Jun 14, 2005
3
US
I would like managers to be able to change the status or location of an employee. I don't want them to see all the records but just the employee they need to change. Can I create a form that will take them to a particular record in a table?

Thanks for the help! Bevo48
 
You could create a Quick Browse Combo Box in the form header section of your form. This box cboEmployee, should be an unbound box drawing information from your Employee table, ie. Name and employee ID.

Once you create the cboEmployee box create a second box in the detail section called txtEmployeeID which will include the employee name or whatever identifying information you would like.

Then, select the event tab from the properties box for the cboEmployee. Press the builder button (...) and type the following code.

Me.txtemployeeid.SetFocus
If Not IsNull (Me.cboEmployee) Then
DoCmd.FindRecord Me.cboEmployee
End If
End Sub

I hope this helps...

Sahaitu

""Third Eye Development, LLC
 
Or simply follow the 3rd option of the combo wizard.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Also take a look at the FilterOn and Filter properties of the form.

Ken S.
 
Thanks for the help. I was able to set up the combo box to find the record I am looking for. Is there a way to make the form be blank when it is first opened? Thanks Again.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top