Search in subform

[rothjm]

I have a quick and dirty database (attached) for tracking cath lab procedures. I had to import from an existing spreadsheet so that is why some of the fields aren't as disireable as I would like. Anyway, I need to be able to search by procedure number which is on the subform. The link is between patId for master/child links. How do I go about this?

I have searched the site but I haven't found a solution to use in my situation...probably because I am a newby and I am not very Access savy yet.
I would appreciate for any assistance!

 

[rothjm]

fyi - This attachment is Access 2000.
Thanks

 

[rothjm]

TTT

Really need some assistance!
THANKS

 

[chanson]

I am unsure of what your actual question is, is there a specific part of the search process that you are having a problem with or do you not know how to do it at all?

 

[rothjm]

I couldn't get it to work at all.
When I tried...it would only search the record displayed in the subform....if wouldn't search all records.
I don't really know how to do it....I had just tried the wizard to create a button with the search feature.
Thanks

 

[chanson]

I think this is what you are trying to do. Take a look at this database, I added the search button with the corresponding code and modified the record selection buttons. I didn't know if you were going to want them to search by partial numbers or not so I have both options available. I have I setup so it will take partial numbers now, you can look at it and see the two different lines of code and remove the one that you don't want. Hopefully this helps!

 

[rothjm]

Thanks, I appreciate your time.

You are close to what I am trying to do.
Your code seems to filter out only the "input" record.
Can I just jump to that record and still show the other records for that patient?
Like if a patient had 5 different procedures, your search only shows the one entered.

Again, I appreciate your efforts. Maybe you have pointed me in the right direction.
Thanks
Jeff

 

[chanson]

Okay, I have some code that will do what you want but I am about to leave work. If I remember I will try and get an example posted this weekend. I actually got the code of this website, I can't remember what I searched on though. Maybe someone else can help.

 

[rothjm]

Still struggling

TTT
I am still struggling to make this search in the subform work: textbox and then the go button.

Any assistance is greatly appreciated!
Jeff