Recent content by natekris8183

This is what I came up with, but for some reason its asking me for a paramete value for Me.MemSSN whereas I use that Text Box in all my other listbox searches. strSql = "SELECT tblScheduledFollowup.[ID], tblScheduledFollowup.[SFBranchNum], tblScheduledFollowup.[SFUserID]...

I'm not quite sure I am following you. I have several listboxes on another page that look for SFMem (which is triggered by social security number), however rather than having multiple tables with separate data (i.e. checking table, savings table, etc.) I used the following to filter what I...

I have a schedule to schedule follow-up calls, and when it pulls the record up for the parrticular client it would show any current scheduled follow-up calls as well as completed ones. However, to differentiate I want the two listboxes to search when the Completed box is True for completed and...

Earlier I posted about multi searching listbox results, however that was with just at text in addition to a textbox. The problem I am not having is that I have to listbox search that pull from one "Scheduled follow-up" table. I need to pull in one listbox the results for 'open' (which I will be...

OK... so I am having a similiar issue, and likely it will be as simple a fix, but it's between to filtered listboxes however instead of text such as above, this time I need two different AND's. The first to look and see if the "date" rate is <>0, so that it filters the first listbox for SFMem...

Worked perfectly. I HATE those ah-ha moments, because as soon as you said it I realized how simple it was. THANKS!

I apologize, please ignore the descriptions. This VBA was written for a member search function then just copied over to the main form, so I haven't cleaned up the descriptions. Hopefully this makes since, but there are 2 listboxes searching for deposit products (one list box filters SSN and...

I have hit a minor road block. (AC 2010) We are putting together a CRM (this is a patchwork fix probably for the next 24 months while we implement something more robust). There are several custom search boxes that automatically updated on the main member profile record form to show certain data...