searching for records based off of one field from a table.

[Chekotah]

I have a database that I am creating for my work. I have a form that I am trying to get it to search the information from a table to pull the record on the form. I would like to search infomation such as employee id and wanting it to pull that information from the table.

[Chekotah]

Ok i have fix this issue by creating ia unbound combo box. however now i need it to pull to a blank record so i can add a new record. any suggestions.

[ItsMe]

I think the following will do the trick

DoCmd.GoToRecord , , 5

Where the index 5 represents the constant acNewRec
http://msdn.microsoft.com/en-us/libr...ffice.15).aspx

[Chekotah]

Thank you for responding and for you help. However I am still a bit confused.
Here is the code that is currently on the db. However, I am not sure where to change the information to for it to pull a blank form when opening the form. I also need it so it will allow me to search the employee ID field for the records already in the form as well as create a new one when a new employee comes on board. I currently have this combo box attached to the Employee ID field and it will pull the appropriate information pertaining to that employee ID.
Private Sub Combo86_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Employee ID] = " & Str(Nz(Me![Combo86], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
Private Sub Add_Record_Click()
On Error GoTo Err_Add_Record_Click
DoCmd.GoToRecord , , acNewRec
Exit_Add_Record_Click:
Exit Sub
Err_Add_Record_Click:
MsgBox Err.Description
Resume Exit_Add_Record_Click

End Sub

[ItsMe]

The code you posted looks good. Is it not working for you?

You can place the following in the form's load event
DoCmd.GoToRecord , , acNewRec

And it will open to a new record. Is this what you mean by "Blank"? A record will not be created/saved until after some data is typed into a bound control and said control loses focus.

DoCmd.GoToRecord , , acNewRec
is the same as
DoCmd.GoToRecord , , 5

I think it needs two commas. My original code I posted only has one. I am going to edit it now.

[Chekotah]

Thank you now i have a blank screen other than the employee ID field which is were the combo box is located. is there a way to for that not to show up.

I appreciate all you help.

[ItsMe]

You can use the property sheet to set the property for your control. Setting the Visible property to No will hide the control from the user. You can do this in VBA too. For instance, the Form's Load event could have the following

ControlName.Visible = False

THis would do the same thing as setting the default in the property sheet. The difference with VBA is that you can choose events to change the properties back and forth at will.

[Chekotah]

Thank you. That worked. Now on to the next phase of this. Creating a sign form so multiple users.