problem displaying specific record

#1 (**permalink**) 28-Jul-2006, 08:30 AM

Hi,
I have written this code below and it executes but does not do what I
want it to do. What I want is the form "Sparesform" to open when I
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12605-problem-displaying-specific-record.html
double click on the "index" field for the record I wish to view. The
index field is part of a subform. What is happening at the moment is
the form "Sparesform" is opening but does not go to the correct record
but instead goes to, what appears to be a new record. My where
condition of the code appears to be assigning the correct index number
to "forms![sparesform]![number]" but this does not seem to be carried
out when the sparesform is opened.

Index is a numeric data type (ie its an auto number)
Can you shine some light on my problem.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605

Private Sub index_DblClick(Cancel As Integer)

Dim stDocName As String, stLinkCriteria As String

stDocName = "Sparesform"
stLinkCriteria = "forms![sparesform]![Number] = " & Me![index]

DoCmd.OpenForm stDocName, , , stLinkCriteria
Forms![sparesform]![Condition].SetFocus

End Sub

Yours truly,
Martin R

#2 (**permalink**) 28-Jul-2006, 08:30 AM

MartinR wrote:
> Hi,
> I have written this code below and it executes but does not do what I
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605
> want it to do. What I want is the form "Sparesform" to open when I
> double click on the "index" field for the record I wish to view. The
> index field is part of a subform. What is happening at the moment is
> the form "Sparesform" is opening but does not go to the correct record
> but instead goes to, what appears to be a new record. My where
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605
> condition of the code appears to be assigning the correct index number
> to "forms![sparesform]![number]" but this does not seem to be carried
> out when the sparesform is opened.
>
> Index is a numeric data type (ie its an auto number)
> Can you shine some light on my problem.
>
>
> Private Sub index_DblClick(Cancel As Integer)
>
> Dim stDocName As String, stLinkCriteria As String
>
> stDocName = "Sparesform"
> stLinkCriteria = "forms![sparesform]![Number] = " & Me![index]
>
> DoCmd.OpenForm stDocName, , , stLinkCriteria
> Forms![sparesform]![Condition].SetFocus
>
> End Sub
>
> Yours truly,
> Martin R

Your where clause does not need to refer to the form like that (the form
knows who it is). Just use...

stLinkCriteria = "[Number] = " & Me![index]

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

#3 (**permalink**) 28-Jul-2006, 08:30 AM

cheers for the advice but when i changed that, a message box comes up
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605
prompting me to enter a number, when i put in a number it still does
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605
not open the record with that index number but instead it opened the
first record! i dont want to have to enter in the number if i am
clicking on the one that i want to go to. Do you think my code is wrong?

#4 (**permalink**) 28-Jul-2006, 08:30 AM

MartinR wrote:
> cheers for the advice but when i changed that, a message box comes up
> prompting me to enter a number, when i put in a number it still does
> not open the record with that index number but instead it opened the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605
> first record! i dont want to have to enter in the number if i am
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605
> clicking on the one that i want to go to. Do you think my code is
> wrong?

Yep. When you are prompted for a field it usually means the field does not
exist or that you spelled it wrong.

Open the form normally to record one (no filter). Click into the [Number]
field and press the "Filter By Selection" button in the toolbar. That will
apply a filter that specifies the record that you are currently sitting on.
Now switch to design view and examine the filter string that was created by
what you just did. That is what the WHERE clause you are sending should
look like. Does it?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

#5 (**permalink**) 28-Jul-2006, 08:30 AM

When i click the filter by selection button and then go into design
view, where do i view the code behind this??
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605

#6 (**permalink**) 28-Jul-2006, 08:30 AM

MartinR wrote:
> When i click the filter by selection button and then go into design
> view, where do i view the code behind this??

Just look at the Filter property of the form on the {Data} tab of the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605
property sheet.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

#7 (**permalink**) 28-Jul-2006, 08:30 AM

Opposite filter lookup on the data tab it says Database Default. Is
this the setting i require?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605

#8 (**permalink**) 28-Jul-2006, 08:31 AM

"MartinR" wrote in message
news:1152172057.102110.262860@m79g2000cwm.googlegr oups.com...
>
> Opposite filter lookup on the data tab it says Database Default. Is
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605
> this the setting i require?

No. Make sure the property sheet is showing properties for the form (not an
object on the form) by clicking on the small gray square in the upper left
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605
corner of the form in design view. On the {Data} tab the second item listed
should be the Filter property.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

#9 (**permalink**) 28-Jul-2006, 08:31 AM

This is what it says in the filter part under the data tab.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605
((Spares.[No]=651))

What way should i now change my code?