Sometimes Won't Find Previous Records

[billgyrotech1]

Hello,

Hold down shift key when opening database. On my AFRs Form in the AFR Number field sometimes it won't find previous AFR Numbers. I use Ctrl+F to find the numbers.

Some example numbers:



85637
83115
83733
88888

Can someone please try to see why?

Thank you

[orange]

I looked at your code briefly. I commented out a few lines on your SwitchBoard form as below

Private Sub Form_Load()
    'Hide ribbon
   ' DoCmd.ShowToolbar "Ribbon", acToolbarNo
   ' DoCmd.Maximize
    'Hide navigation pane
    DoCmd.SelectObject acTable, , True
    'DoCmd.RunCommand acCmdWindowHide
End Sub

I took screenshots
-first (Bill) while on AFR 83115,did ctrl F and set the Find to look for 88888, and
-second (Bill2) showing the result AFR 88888.
-third (Bill3) while on AFR 88888, ctrl F to find 83733 UP/Previous
-Fourth (Bill4) result of Find in Bill3.

I don't know what causes some AFRs to NOT be found -- unless you're checking Up/Down incorrectly. I would expect All to work(since it should do the search in any.all directions). Seems to find AFRs for me, but I did not try all of your values.

Good luck with your project.

[billgyrotech1]

Thank you for helping. If I search through those numbers multiple times back and forth sometimes it doesn't find.

[isladogs]

Why not try using a combo listing all existing values to run your searches as I suggested in your previous thread.
Doing that means users don't need to use Ctrl+F and nor do they need to know which values already exist

[billgyrotech1]

Actually something must be wrong because Ctrl+F should find a previous record every time but it isn't.

There must be some underlying cause.

I really appreciate it if someone can find the reason.

Thank you

[orange]

When a user "needs" to Find a record/AFR, what exactly do they use for criteria? I guess I'm really asking what is the "business requirement" for Finding a record? Edits/Updates to existing records; creating new records?
As Colin said creating a combo based on AFRId, and/or Clerk and/or Customer and/or Description and/or Complaint may all be valid searches. But we don't know your business. All seem reasonable choices.

Lots of tutorials re Comboboxes from techonthenet.

[billgyrotech1]

The business requirement to look at history for warranty purposes or general history of a customer by the amount of AFR Numbers. We have used Ctrl+F to find previous serial numbers or part numbers or Customer names.

[isladogs]

Yes I know you have used Ctrl+F but for whatever reason its problematic.
Its not the standard way of searching as it requires users to know which numbers are valid
The fact that you needed to suggest valid numbers reinforces that point.

I'm suggesting using a better method rather than spending time trying to fix a less good method.

[billgyrotech1]

Okay isladogs I am willing for sure since you are much more experienced than me.

[mike60smart]

Standard method is a Combobox as suggested by Colin

See attached example.

I made the form based on the AFR table and not a query in order to allow for searching using a Combobox. If it is based on a query then this facility is not available.

[orange]

Mike,
I agree that your combo can find and display specific AFR. But from the OP's perspective, does the user really know (for certain) the 5 digit AFRId? It many cases to find records there is a need to do a partial match on Customer, or Product or Complaint etc (pick an environment where someone remembers part of something -- sort of Browse to Find the One I mean).
Don't get me wrong --designed combo approach(es) is more comprehensible than Ctrl F and guess which control to search.

[isladogs]

@mikesmart
Disagree with your comment about queries and combos.
Combos can be based on queries or sql statements as well as tables. Any of those are suitable for a row source and can be used in a search form.

[billgyrotech1]

We know the previous AFR number when it gets returned for warranty issue. Then we look up the previous AFR Number to see what was done.

Thanks

[billgyrotech1]

Mike that works great thank you!

What if we looked up a serial number? There may be more than one occurrence however so I'm not sure if this method will work.

[orange]

Bill,

Review this "search" material from Allen Browne.