Open form using vba

[Joe]

I have a table full of names and address. I have a search form with a text
box for data I enter and a combo box that lists the fields of the table. I
want to search the selected field of the combo box for the data I enter in
the text box. For example I type a last name and then select last name in
the combo box. I want the on click event to open up a form "search results"
showing the record that matches the last name or whatever data I type and
select. Any help???

 

[Douglas J. Steele]

Try something like:

DoCmd.OpenForm "MyForm", _
WhereCondition:="[MyField] = " & Chr$(34) & _
Me.MyCombobox & Chr$(34)

Replace MyForm, MyField, MyCombobox with the actual names.

If you wanted to have a text box that you could type part of the name in,
you could use something like:

DoCmd.OpenForm "MyForm", _
WhereCondition:="[MyField] Like " & Chr$(34) & _
Me.MyTextbox & "*" & Chr$(34)

 

[Joe]

I appreciate the quick response but it still gives me a blank result. No
error either.

Try something like:

DoCmd.OpenForm "MyForm", _
WhereCondition:="[MyField] = " & Chr$(34) & _
Me.MyCombobox & Chr$(34)

Replace MyForm, MyField, MyCombobox with the actual names.

If you wanted to have a text box that you could type part of the name in,
you could use something like:

DoCmd.OpenForm "MyForm", _
WhereCondition:="[MyField] Like " & Chr$(34) & _
Me.MyTextbox & "*" & Chr$(34)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have a table full of names and address. I have a search form with a text
box for data I enter and a combo box that lists the fields of the table.
I
want to search the selected field of the combo box for the data I enter in
the text box. For example I type a last name and then select last name in
the combo box. I want the on click event to open up a form "search
results"
showing the record that matches the last name or whatever data I type and
select. Any help???

 

[Joe]

I have also tried this but it does not work either. But I do know that the
strings are working properly. I used msgbox to display their values.

Dim field As String
Dim search As String

field = [Combo6]
search = [namebox]

DoCmd.OpenForm "testdata1", _
WhereCondition:="testdata!field" = "search"

 

[Douglas J. Steele]

What exactly did you use? The code you posted elsewhere in this thread
(WhereCondition:="testdata!field" = "search") is definitely incorrect.


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I appreciate the quick response but it still gives me a blank result. No
error either.

Try something like:

DoCmd.OpenForm "MyForm", _
WhereCondition:="[MyField] = " & Chr$(34) & _
Me.MyCombobox & Chr$(34)

Replace MyForm, MyField, MyCombobox with the actual names.

If you wanted to have a text box that you could type part of the name in,
you could use something like:

DoCmd.OpenForm "MyForm", _
WhereCondition:="[MyField] Like " & Chr$(34) & _
Me.MyTextbox & "*" & Chr$(34)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have a table full of names and address. I have a search form with a
text
box for data I enter and a combo box that lists the fields of the
table.
I
want to search the selected field of the combo box for the data I enter
in
the text box. For example I type a last name and then select last name
in
the combo box. I want the on click event to open up a form "search
results"
showing the record that matches the last name or whatever data I type
and
select. Any help???

 

[Joe]

I used the code you suggested, both ways and it did not work. So then I
tried the other that I pasted in below. Testdata is the table.

What exactly did you use? The code you posted elsewhere in this thread
(WhereCondition:="testdata!field" = "search") is definitely incorrect.


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I appreciate the quick response but it still gives me a blank result. No
error either.

Try something like:

DoCmd.OpenForm "MyForm", _
WhereCondition:="[MyField] = " & Chr$(34) & _
Me.MyCombobox & Chr$(34)

Replace MyForm, MyField, MyCombobox with the actual names.

If you wanted to have a text box that you could type part of the name in,
you could use something like:

DoCmd.OpenForm "MyForm", _
WhereCondition:="[MyField] Like " & Chr$(34) & _
Me.MyTextbox & "*" & Chr$(34)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


I have a table full of names and address. I have a search form with a
text
box for data I enter and a combo box that lists the fields of the
table.
I
want to search the selected field of the combo box for the data I enter
in
the text box. For example I type a last name and then select last name
in
the combo box. I want the on click event to open up a form "search
results"
showing the record that matches the last name or whatever data I type
and
select. Any help???

 

[Douglas J. Steele]

Copy and paste the code you're trying to use. That's the only way we'll be
able to spot if you made typos in it.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I used the code you suggested, both ways and it did not work. So then I
tried the other that I pasted in below. Testdata is the table.

What exactly did you use? The code you posted elsewhere in this thread
(WhereCondition:="testdata!field" = "search") is definitely incorrect.


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I appreciate the quick response but it still gives me a blank result.
No
error either.

:

Try something like:

DoCmd.OpenForm "MyForm", _
WhereCondition:="[MyField] = " & Chr$(34) & _
Me.MyCombobox & Chr$(34)

Replace MyForm, MyField, MyCombobox with the actual names.

If you wanted to have a text box that you could type part of the name
in,
you could use something like:

DoCmd.OpenForm "MyForm", _
WhereCondition:="[MyField] Like " & Chr$(34) & _
Me.MyTextbox & "*" & Chr$(34)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


I have a table full of names and address. I have a search form with
a
text
box for data I enter and a combo box that lists the fields of the
table.
I
want to search the selected field of the combo box for the data I
enter
in
the text box. For example I type a last name and then select last
name
in
the combo box. I want the on click event to open up a form "search
results"
showing the record that matches the last name or whatever data I
type
and
select. Any help???