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
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12605-problem-displaying-specific-record.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605
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.

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
> 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...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605

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
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?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605

#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
> 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?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605
view, where do i view the code behind this??

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

MartinR wrote:
> When i click the filter by selection button and then go into design
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605
> 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
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605
this the setting i require?

#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
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605
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.
((Spares.[No]=651))

What way should i now change my code?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12605