Search results

@vbaInet Thanks for the debug tip! I'll give it a try later today, hopefully. (All sorts of meetings at work all day :( ). Hopefully it will pinpoint where something is missing! Thanks again for all your help!

@vbaInet Okay so that fixed the type mismatch error, but the code does not change the current displayed record in the combo box. Thanks, Ben

I'm a bit confused by the quoted post below, did you look at the screen shot I provided? You will see that the line is in the code exactly as you typed it to me in the previous post about explicitly casting. I hovered over the yellow line with the mouse and that is the message that pops up when...

:( Still receiving the same type mismatch error (see attached screenshot). This is confusing and I appreciate your help with this! Thanks again.

The line I pasted over my code was copied from your post directly and is: If cboSearchColorNum(0, i) & "" = Nz(Me.txtHiddenColorNum, "") Then The message I typed about the <type mismatch> comes up in the debugger when the line above is highlighted yellow and I hover over the line with my...

@vbaInet Still getting the type mismatch which is highlighting the new line you gave me to replace my If statement. The type mismatch is stating: If cboSearchColorNum (0,i) = <type mismatch> Thanks for your continued help!

@vbaInet One more question: does the code need to be placed inside the Form's On_Current event or can I put the code in where I make my On Key Down event for the combo box? This is what I was going to try and then got a type mismatch... Private Sub cboSearchColorNum_KeyDown(KeyCode As...

@vbaInet Okay, so I guess my issue is that the only place the Color Number value shows up on the form is the combo box. So if I were to try to compare the Color Number of the current record to something, would I need to create a new field (maybe hidden) which would hold this value for the form...

@vbaInet Okay, I think I understand your suggestion: If I programmatically set the SELECTED value to the value of the newly "current" record (the record I have just moved to) then that new displayed value should show up. I have some questions about the code you posted though: The...

@vbaInet Ah! Well in that case, it is not bound as the Control Source is empty. There is a row source that populates the combo box with the available Color Numbers from the manufacturer's table. Any thoughts on how to update the combo box's displayed value when I move to the next record using...

@YNWA: That was my thought, though I cannot seem to find a way to refresh the value of the combo box. I believe it is a bound combo box (as when I look at the properties it states "Bound Column: 1".) I do not know how to refresh the value to reflect the next record when the form moves to the...

Hi. So a brief explanation of the project: A Gel database which holds an inventory of our company's current gel stock by manufacturer, including counts of different size gels and a description of the gel with primary keys being "Color Number" for each manufacturer's table. I have built a...

Hello everyone! I'm a bit of a novice programmer in general, though more novice in VBA than some other languages. I am currently employed at a performing arts center and due to the fact that I have the most computer skills and programming knowledge, I've been tasked with updating some of their...