Search results

thanks vbaInet. Really appreciate your time and patience. I removed all references to ObstetricsForm but it gave me run-time error'3075': syntax error in string .Filter = "[TripID] Like '*" & cmdSRCHBOX.Text & "*' OR [PatientID] Like '*" & cmdSRCHBOX.Text This is the code I...

in this form, ObstetricsFormResult would be a tab page. I could not add a subform to the tab control because for some reason, when I tried, it covered the other controls there. I could not "bring them to the front" if there is such a thing in VB.

please see the attached :banghead:

forgot to add: when I used the WITH code, I got Run-time error '438': object doesn't support this property or method

hey vbaInet, I put the first part of the 2 codes below in the change event of cmdSRCHBOX but got this error: Run-Time error '424': object required:confused:

Thank you!! I'll work with this and post back an update:)

hi vbaInet. I really appreciate your patience and help. I put this code which CJ London provided in the change event of the search box but the ELSE line is highlighted in red. what could be wrong with it?:banghead: my form is called ObstetricsForm and the searchbox is called cmdSRCHBOX...

hey vbaInet, I was referring to your point about giving total control to the user and easing the 'pressure' on the database. if one were to take the route of giving control to the user, what would this entail? would it still need the search box or just the search button in addition to the two...

hey CJ London, I am not using subforms on my form but a tab control with pages. I later tried to add a subform but it was covering other controls on the tab page so I removed it. my form is called ObstetricsForm and the tab control Tabct1147. I have removed the pipe from the below code but not...

only just seen your illustration CJ London with the figures. Thank you!! I think one reason why I was confused there was that, I'd created my form as a single form not as a continuous form. I could not visual what you were saying there for a sec. So in essence, until all the search criterion is...

thanks vbaInet and everyone. I'm taking every advise in and trying to process them. CJ London, please, please bare with me. I'm still wondering what the user'd type into the searchbox...:confused: when two fields are required?? If they've already typed in, in both fields then clicking the...

CJ London, since these two data have to be provided for the record to be identified, I think placing a search button beside them is the way to go. The only trouble I anticipate is my current table validation rule: If the TripID and PatientID fields are not null, then [Condition] is not null...

the challenge I'm having on that is, each record in the database is uniquely identified by two fields, not one. The search will require both the TripID and PatientID to pull up the record...

thanks AccessBlaster & CJ London!! excuse my limited knowledge but just to be clear on this statement: "By contrast pressing a button to see your search results is lighting fast especially when you set an index or two" you mean having a button beside the searchbox, right?

Thanks CJ London. have a great weekend ALL!!:)

Many thanks for this vbaInet

My table has a compound primary key consisting of Trip_ID and Patient_ID. How can I make my data entry form "search as I type" in this key? The form also has a combo box and many tab controls. I really appreciate any help on this one.

ah! yes master:) that is what I meant "Search as I type"

Perhaps I should be more specific. My table has a compound key consisting of Trip_ID and Patient_ID. The form also has a combo box and many tab controls. I want the form to pull up the data from the Table when I type in the compound primary key. I really appreciate any help on this one.

Okay it looks like I spoke too soon. Please put it down to newcomer excitement. Turns out that they work as long as the Table is closed. How can I make the form auto populate by typing the ID into a textbox control please?