Search results

Hi there, I currently have a form called "Verify Customer Details" which can be accessed from two different forms. Depending upon which form "Verfiy Customer Details" is accessed from, the recordsource needs to be set to the relevant one of two queries. I tried setting the recordsource in the...

Thanks a heap unclojoe, that has fixed the problem! I will now be able to fix all the problematic forms in my db. incidentally, there were no error notices - only a lack of updating. Thanks!

Hi there, In my database I have this problem occurring in several of my forms. The issue is that I perform an operation in one form, which then runs a query to get the desired results, opens a new form with a listbox, which is supposed to display the query results. My problem is that once the...

Done and done! Thanks a lot guys!

OK, next problem! As I originally mentioned, I have two of these list boxes on the form. First one is now sorted. The second one is essentially the same idea, but updates 2 fields in it's table (Brand and Model). The model info comes from a text box, while the brand info comes from the...

Perfect! That did the trick. Thanks a lot!

OK, Thanks for the info. I am assuming the very simple one line of code you replaced mine with is basically an append query? I tried using it instead, but get the error "Too few parameters. Expected 1." Any ideas? I also tried the .Fields change for my original code - same problem, and still...

Excellent point about posting the code Dom, thanks for pointing it out. See below: This first piece of code refers to the first list box (brands). Have also noticed another problem with this particular listbox since original post - after clicking the button to initiate the code, all seems...

Hi, I have a form with two List boxes, each linked to a table. The purpose of the form is to allow users to add new data into the tables the list boxes are reading from. To do this, there is a text box and button for each list box, to add new data. The data from the text box adds to the table...

Thanks!!! Geez, such a simple syntax error!!!! Thanks so much, I'm well under way with that problem solved! :D Jon

Hi there - 1st post so please bear with me! I have currently got a form set up with unbound combo boxes which draw their list info from seperate tables. My idea was to have a user make a selection from these combo boxes, and then use that data to search (please reference form "Inputs 1b -...