combining field

Hi

I have a table called tblDetails and in this table there are 2 field
called strGateID (autonumber) and srtPN which is a default value of
PN. I have combined two field in a query called qrySearch and the new
field is called srtSearchNo.
On my main page frmMain I have a listbox (lstSearch) this displays all
the data in the tblDetails via the qrySearch. When I double click on a
record in the list box I wish it to display all the relevant date on a
new form called frmResults.

Private Sub ShowRecord_Click()

'Find a selected record, then close the search dialog box

DoCmd.OpenForm "frmResults1", , , _

"[qrySearch.strSearchNo]=" & "'" & Me.lstSearch.Column(2) & "'"

'Close the dialog box

DoCmd.Close acForm, "frmMain"

End Sub

only problem is when I run the search it comes up with an error saying

Run-Time errror '3126'
Invalid bracketing of name '[qrySearch.srtSearchNo]


does anyone know how to resolve this?

Thank

Fiona

In this context, you don't include the query name,just the field name. Also,
even if you were using a context that required the query name, the syntax is
incorrect:

Sould be:
"[strSearchNo]="

Correct syntax for recordset use:
[qrySearch].[strSearchNo]
--
Dave Hargis, Microsoft Access MVP


" wrote:

Hi

I have a table called tblDetails and in this table there are 2 field
called strGateID (autonumber) and srtPN which is a default value of
PN. I have combined two field in a query called qrySearch and the new
field is called srtSearchNo.
On my main page frmMain I have a listbox (lstSearch) this displays all
the data in the tblDetails via the qrySearch. When I double click on a
record in the list box I wish it to display all the relevant date on a
new form called frmResults.

Private Sub ShowRecord_Click()

'Find a selected record, then close the search dialog box

DoCmd.OpenForm "frmResults1", , , _

"[qrySearch.strSearchNo]=" & "'" & Me.lstSearch.Column(2) & "'"

'Close the dialog box

DoCmd.Close acForm, "frmMain"

End Sub

only problem is when I run the search it comes up with an error saying

Run-Time errror '3126'
Invalid bracketing of name '[qrySearch.srtSearchNo]


does anyone know how to resolve this?

Thank

Fiona

hi,

Iv added that code and now its coming up with a parameter value box
with qrySearch.strSearchNo so i take it its looking for some sort of
values
or somit.. why is this occuring

figured out the prob its working no.. am soo chuffed
thanks

Is the form with lstSearch open and populated?
--
Dave Hargis, Microsoft Access MVP


" wrote:

hi,

Iv added that code and now its coming up with a parameter value box
with qrySearch.strSearchNo so i take it its looking for some sort of
values
or somit.. why is this occuring