If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
combining field
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 |
#3
|
|||
|
|||
combining field
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 |
#4
|
|||
|
|||
combining field
figured out the prob its working no.. am soo chuffed thanks |
#5
|
|||
|
|||
combining field
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 |
Thread Tools | |
Display Modes | |
|
|