combining field

[fiona.innes]

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

 

[Klatuu]

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]

 

[fiona.innes]

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

 

[fiona.innes]

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

 

[Klatuu]

Is the form with lstSearch open and populated?