Recent content by jsdavis

Hello, I have a question about getting results sorted. Here is my code: Private Sub cmdSearch_Click() If Len(cboSearchField) = 0 Or IsNull(cboSearchField) = True Then MsgBox "You must select a field to search." ElseIf Len(txtSearchString) = 0 Or...

PHV, That worked great. Thank you again for your help! You rock! God Bless- jsdavis

I have been looking up a ton of threads on this form trying to get exactly what I need but I still can't figure it out with what I've found. I'm sorry if this simple question has already been answered... I have a report called CDIBReport which is fed from a query called CDIBQuery which...

Pampers, You are brilliant! :) It's so simple and it works great! Thank you so much! God Bless- jsdavis

I have a combo box in a search form that I want to use to repopulate a form with. I pull up records that match a certain criteria into a combo box. I want to be able to click on a certain record listing from the combo box and have that record information populate a form. Here is the basic...

PHV, That works wonderful! Thank you for that! :) Now, what would I need to do to be able to click on one of my "results" of my search in the combo box and have it then populate a form that is already set up with the appropriate fields for the record? I know it's obviously an onClick command...

TheAceMan1, I guess that's what I need to do. I'm trying to find a way to search records in a table (linked to a form) by one of multiple fields (First Name, Last Name, Middle, SS#, Mother of person, Father of person) which I already have set up in a combo box. Once I choose a Search Field, I...

I am trying to create a search form that searches based on a Field and Criteria selection and then sends the records that match the criteria to a combo or list box with only certain fields showing up (i.e. only first, last, middle, SS#). I would then like to be able to click on/select any of...