From Command button, Find records beginning with ID#

[SherryScrapDog]

ID# is the primary key. I have a form where you can enter an ID and the
Command button finds the record that is equal to the ID. This uses
stLinkCriteria (through the wizard). What I really want is for all the
records beginning with the ID entered to be available on the form. I can't
make an 'Or' condition work with the stLinkCriteria and that may be because
I'm still in early learning process. I can change the condition to be > than
the ID and that works fine, except it does not show the record the person
actually entered; it begins with the next record. I thought maybe I could
programmatically somehow change the value of ID (in VBA) to subtract 1 from
it, but I do not know how to do that. (And I guess I would need to make sure
the number entered wasn't already a 1). Any suggestions?
Thanks for any help you may have! Sherry

 

[Steve Schapel]

Sherry,

The symbol for "equal to or greater than" is >=

 

[SherryScrapDog]

Thanks so much Steve! I was using => and that didn't work. I never would
have thought to switch them around. Works like a charm now!
Many, many thanks, Sherry