i am using the following code to open a listbox that allows me to select a person from the 'master name' file, and then place that persons ID into a different form that is based on the 'master name' file.  

I want to modify so that I can search for the person, select them from the listbox list, and then have just their 'person ID' field information put into a different form which is not based on the 'master name' form.  The 'person ID' is used to link the new form to the 'master name' file.

Is there a way to do this without having to have the 'master name' form open?

Here is the code:

Option Compare Database

Private Sub LIst8_AfterUpdate()
    ShowRecord.Enabled = True
End Sub

Private Sub List8_DblClick(Cancel As Integer)
    If Not IsNull(List0) Then
        ShowRecord_Click
    End If
End Sub

Private Sub ShowRecord_Click()
    Dim rst As DAO.Recordset
    Set rst = Forms![Master Name].RecordsetClone
    Forms!WarningsTickets!txtPerson_ID.Value = rst.Fields("Person_ID") & Me.List8
    DoCmd.close acForm, "GotoRecordDialog8"
End Sub
Private Sub cancel_actioni_Click()
On Error GoTo Err_cancel_actioni_Click


    DoCmd.close

Exit_cancel_actioni_Click:
    Exit Sub

But with this code I am forced to have the 'master name' form open.  Which is a hassle in the simple running of the database operations by a user.

Thanks for any fixes you can come up with.

MAC

Offhand, you could try storing the variables, and other information that you need from the first form into: 1) a table, 2) variables. (ie. table name to open, ID of person, et cetera)

Then in the next form, you can just access the new table (or variables) and use them, instead of the references to the master form.

Although, you could possibly just hide the master form, then make it visible again when needed - leaving the code as is otherwise.

quote:

---

chief_wpd wrote:
i am using the following code to open a listbox that allows me to select a person from the 'master name' file, and then place that persons ID into a different form that is based on the 'master name' file.  

I want to modify so that I can search for the person, select them from the listbox list, and then have just their 'person ID' field information put into a different form which is not based on the 'master name' form.  The 'person ID' is used to link the new form to the 'master name' file.

Is there a way to do this without having to have the 'master name' form open?

Here is the code:

Option Compare Database

Private Sub LIst8_AfterUpdate()
    ShowRecord.Enabled = True
End Sub

Private Sub List8_DblClick(Cancel As Integer)
    If Not IsNull(List0) Then
        ShowRecord_Click
    End If
End Sub

Private Sub ShowRecord_Click()
    Dim rst As DAO.Recordset
    Set rst = Forms![Master Name].RecordsetClone
    Forms!WarningsTickets!txtPerson_ID.Value = rst.Fields("Person_ID") & Me.List8
    DoCmd.close acForm, "GotoRecordDialog8"
End Sub
Private Sub cancel_actioni_Click()
On Error GoTo Err_cancel_actioni_Click


    DoCmd.close

Exit_cancel_actioni_Click:
    Exit Sub

But with this code I am forced to have the 'master name' form open.  Which is a hassle in the simple running of the database operations by a user.

Thanks for any fixes you can come up with.

MAC

---