Search results

/facepalm alright the reason the recordset=nothing is because my combo box was unbound...this problem does not occur for bound combo boxs

Alright I managed to solve it with some trial and error. In case anyone else runs into this problem here was my solution. Set Me.cboCompany.Recordset = Me.RecordsetClone Using the class module found in the linked database above calls on the referenced combo box's recordset, but evidently, when...

Here is a dumb'd down version of the database. Though the file type is mdb for the actual database. Youll see when you open the form that the form displays the error. If you open the form in design mode and then back to normal it works perfectly...Ill take another look at it but my brain is...

Unless recordset is the same as recordsource I am not sure where to do that. My recordsource is already set and i attempted to set it through vba with the 'on load' event thinking it wasnt triggering before the module but that was not the case. Unfortunately I need to leave my computer for a...

Hopefully someone can help me since I have already spent far too much time trying on my own with little success. I am using a module from tek-tips called "FindAsYouType" which allows my combo box to search Like *text* and not Like *text. Unfortunately when I open the form containing the combo...

Perfect! thats exactly what i needed, Thankyou so much Stopher and everyone else who took time to respond.

ill definately check this out! im sure you all are dead on about it being simply a query solution and i just have not thoroughly examined it :/ Thanks again!!

Alright well for some reason i cant zip the file down to a size that is small enough despite removing everything but the table and form...ill try again later when my headache leaves and im thinking clearly. I probably was a bit confusing in my first post unfortunately...a simple way to explain...

Hello! First time poster but certainly not new to the forums as i have relied on everyones vast superiority in access since my knowledge is limited to say the least... I am trying to figure out how i can solve my situation. My best guess is a Do While Loop but i have never tried one. A...