Search results

ok, I get that but how would I do it when I have multiple combo boxes filtering multiple queries?

I don't know what you mean by "bound" I just started adding stuff to it in design view from a blank form

ya, I get the same error message each time and it highlights this part in the code Me.RecordsetClone.FindFirst "[ID] = " & Me.cboOptions.Column(0)

Ok, that helped for the new input but for the list selection, it's still giving me the 7591 Runt time error

hey RG, it's me again I tried to implement what you did in that sample db into mine. I basically copied and pasted the code but it doesn't seem to want to work for me. When I go to select an item from the list box, I get "Run-time error '7591', improper reference to the RecordsetClone...

Yes, that is exactly what Im looking for I can't thank you enough Rural Guy. This addition was kinda just thrown at me last minute and I really didn't have a clue how to do it. Now I think my boss will be quite impressed with this db Thank you again 1000 times over

Thank you for all your help RG one more question if you've got the time/patience to help me out: I would like to be able to include "Cost" text box for these options so that when an existing option is picked, the cost of that one will be shown and when a new option is inputted, you can type in...

Here is the sample of what I'm kinda going for your further help is appreciated in this RG

here's the row source SQL SELECT tblOptions.ID, tblOptions.Options FROM tblOptions; I'm off work in 10 minutes, but I'll try and get a stripped down copy tomorrow morning thanks again for all your help RG

on this, should "MySQL" be "strSQL"?

yes to both and I've checked that I spelled all the references correctly

no, nothing was added

Thanks for your reply RG I did as you said, and nothing happens. I type in something that's not in the list and hit enter, and it just goes to the next item on the form

Thanks for the link RuralGuy I think I understood what was going on in the article, but I tried using it and changing the names and stuch, but it doesn't seem to do anything for me. Here's the code, maybe I missed something? Private Sub cboOptions_NotInList(NewData As String, Response As...

/bump sorry guys, I need an answer for this :o

Hi guys, I'm looking for a little bit of help here. I have a form and on this form I have a combo box. Now this combo box is populated by a table that I have called "Options". So this is all fine and dandy to select items already existing in the table, but ideally I would like to be able to...

Yes this worked, thanks Rich But I'm still confused as to why it worked when I opened the subreport on it's own and it didn't when I opened it with the main report

Hey guys, I seem to be in a bit of a pickle. I have a subreport embedded in my main report and a second subreport embedded in the first subreport (3 levels). On this subreport, I have a text box in which I do a simple total calculation on which I do a summation of data from the 3 subreport and...

Ok, here's an update. Apparantly if I change the file type to .rjf this problem can be solved. Thing is, I looked at it for about an hour and can't figure out how I would change the file type. Any suggestions?

I've been working on a database for the last month or so. It's been a slow process since I've been learning Access and VBA in the process. But my supervisor wanted a copy of it as a progress check to send to his boss. So I sent an email with a copy of the database as an attachment. THe email...