Can i do a search on a value in a form and a subform?

[Daveed1973]

I have a main form created which has a subform allowing multiple inputs of
Trustee names.

I have created search form which has an unbound box used for the search on a
unique ID on the main form. But what I need to do is be able to search by the
Surname from the Trustee subform and also by the unique ID on occasions.

For example. the user would search by the Surname of Smith to show the main
form with all Trustee details shown in the subform for the Surname Smith.
Should they want to narrow the search down they would use both the Surname
and the unique ID.

Is there a way of doing this?

 

[Wayne-I-M]

Hi

Not really sure it is you are trying to do but I "think" you are looking for
a name search.

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

Create an unbound combo (cboNameSearch) and have the columns set as
0cm;2cm;2cm
the 1st column (bound coulm) is the ID field and the 2nd column is the
surname. The 3rd coumn could be the first name
Use the wizard to create the combo source query if you need to.

As I said sure exactley what you're doing so if I'm am wrong post back to
see it you get another answer

 

[Daveed1973]

I want to have a form which will allow me to search for a unique ID and/or
the Surname of a Trustee.

I have two tables - a Trusts table and a Trustees table with the information
from these being displayed in a form. The Trusts table makes up the main form
whilst the Trustees makes up the subform on the main form.

Is there a way to enter either the ID or Trustee Surname into unbound boxes
on a form so that when you click the search command button it displays the
above mentioned main form (with subform) but only for records which has
Trustees with the surname Smith for example.

I appreciate your quick response but unfortunately I have only dabbled
slightly with VBA so not to clued up. Dummies VBA would work for me

Hi

Not really sure it is you are trying to do but I "think" you are looking for
a name search.

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

Create an unbound combo (cboNameSearch) and have the columns set as
0cm;2cm;2cm
the 1st column (bound coulm) is the ID field and the 2nd column is the
surname. The 3rd coumn could be the first name
Use the wizard to create the combo source query if you need to.

As I said sure exactley what you're doing so if I'm am wrong post back to
see it you get another answer


--
Wayne
Manchester, England.

I have a main form created which has a subform allowing multiple inputs of
Trustee names.

I have created search form which has an unbound box used for the search on a
unique ID on the main form. But what I need to do is be able to search by the
Surname from the Trustee subform and also by the unique ID on occasions.

For example. the user would search by the Surname of Smith to show the main
form with all Trustee details shown in the subform for the Surname Smith.
Should they want to narrow the search down they would use both the Surname
and the unique ID.

Is there a way of doing this?

 

[Daveed1973]

Sorry, forgot to mention that the Unique ID comes from the Trusts table to
uniquly identify the Trust record.

So it would be tbl_Trusts - Unique_ID and/or tbl_Trustees - Surname I would
need to search on.

I want to have a form which will allow me to search for a unique ID and/or
the Surname of a Trustee.

I have two tables - a Trusts table and a Trustees table with the information
from these being displayed in a form. The Trusts table makes up the main form
whilst the Trustees makes up the subform on the main form.

Is there a way to enter either the ID or Trustee Surname into unbound boxes
on a form so that when you click the search command button it displays the
above mentioned main form (with subform) but only for records which has
Trustees with the surname Smith for example.

I appreciate your quick response but unfortunately I have only dabbled
slightly with VBA so not to clued up. Dummies VBA would work for me

Hi

Not really sure it is you are trying to do but I "think" you are looking for
a name search.

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

Create an unbound combo (cboNameSearch) and have the columns set as
0cm;2cm;2cm
the 1st column (bound coulm) is the ID field and the 2nd column is the
surname. The 3rd coumn could be the first name
Use the wizard to create the combo source query if you need to.

As I said sure exactley what you're doing so if I'm am wrong post back to
see it you get another answer


--
Wayne
Manchester, England.

I have a main form created which has a subform allowing multiple inputs of
Trustee names.

I have created search form which has an unbound box used for the search on a
unique ID on the main form. But what I need to do is be able to search by the
Surname from the Trustee subform and also by the unique ID on occasions.

For example. the user would search by the Surname of Smith to show the main
form with all Trustee details shown in the subform for the Surname Smith.
Should they want to narrow the search down they would use both the Surname
and the unique ID.

Is there a way of doing this?

 

[Wayne-I-M]

It's not too hard to do. But if you don't have the basics of coding you ay
be best using the wizard.

Open the form in design mode and view the tool box. Click the combo tool
and use the wizard to create the lookup as you want it. I would suggest you
create 2 combos one for ech search.


--
Wayne
Manchester, England.

Sorry, forgot to mention that the Unique ID comes from the Trusts table to
uniquly identify the Trust record.

So it would be tbl_Trusts - Unique_ID and/or tbl_Trustees - Surname I would
need to search on.

I want to have a form which will allow me to search for a unique ID and/or
the Surname of a Trustee.

I have two tables - a Trusts table and a Trustees table with the information
from these being displayed in a form. The Trusts table makes up the main form
whilst the Trustees makes up the subform on the main form.

Is there a way to enter either the ID or Trustee Surname into unbound boxes
on a form so that when you click the search command button it displays the
above mentioned main form (with subform) but only for records which has
Trustees with the surname Smith for example.

I appreciate your quick response but unfortunately I have only dabbled
slightly with VBA so not to clued up. Dummies VBA would work for me

Hi

Not really sure it is you are trying to do but I "think" you are looking for
a name search.

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

Create an unbound combo (cboNameSearch) and have the columns set as
0cm;2cm;2cm
the 1st column (bound coulm) is the ID field and the 2nd column is the
surname. The 3rd coumn could be the first name
Use the wizard to create the combo source query if you need to.

As I said sure exactley what you're doing so if I'm am wrong post back to
see it you get another answer


--
Wayne
Manchester, England.



:

I have a main form created which has a subform allowing multiple inputs of
Trustee names.

I have created search form which has an unbound box used for the search on a
unique ID on the main form. But what I need to do is be able to search by the
Surname from the Trustee subform and also by the unique ID on occasions.

For example. the user would search by the Surname of Smith to show the main
form with all Trustee details shown in the subform for the Surname Smith.
Should they want to narrow the search down they would use both the Surname
and the unique ID.

Is there a way of doing this?