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