Searching with subforms

[superrob5]

can someone take a look at my subform database that I created. I would like to know if I go into the cell tabel under the field number and search for the number 3333.

Why does it not go to the second record in the db since that number does show up? IS there a way that I can search for numbers in that field and show the user? Do I have to use a query

 

[Uncle Gizmo]

Can't see what your getting at? Could you provide more info please, I've had a looooong day, and can't think so good... Christ, I'm starting to talk American

 

[superrob5]

sure thing. I had a long day to. Ok say I want to search for a aphone number in the field Cell number in teh cell subform.

If I click in the field and press ctrl F. I get the find button. If I search for a number that is not in that record it will not find it for instance. in the first record there is a number 111-111-111. If I search for 444-444-4444 which is in the 4 record it will not find it. Does that help???

 

[WayneRyan]

Super,

The search works, you have to set the focus to the subform.
Then you have to search by typing:

"(222) 222-2222"

including the parentheses, spaces and dashes.

Wayne

 

[superrob5]

ok I did that and still didnt work. when I am in the empid 1 which has the number (516) 222-1111 and if I search for (222) 222-2222 which is located in empid 2 it doesnt find it.

it seems to only search in that record. for instance in empID 2
there is (333) 333-3333 And (222) 222-2222

I can search for them when I am in that specific record other wise it doesnt allow me to search the entire db.

 

[WayneRyan]

Well,

You can do like the rest of us and write your own search
software. There are plenty of posts here about searching.

I never use that s/w, maybe someone else can shed some
light on it.

Wayne

 

[superrob5]

Thanks I will see if I can find something here. I am still a new access programmer. I can do the basic stuff and a little extra. Maybe someone can help. Thanks

 

[WayneRyan]

Super,

See this thread for a start:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=54341

Wayne