Search results

Hi I created a Frm_InvoiceMain form and a Frm_Subinvoice form. When i created a qry to filter a lstbox for the subform it worked perfectly until i opened it as a subform within the mainform. Query design is attached. As is the message i get when i open the mainform. Not sure how to amend...

Apologies i was being stupid. Unbound controls were throwing me off again.

Hi I have a form header with a search textbox that as i type filters a listbox to show particular products. For exmaple if i type 1234 it will bring up batch 1234 and its variety name of "Apple Blossom". Likewise if i type "App" in the txt box it will filter the listbox and only show all...

Hi MAjP Like PBaldy said, didnt mean was complicated to use, just meant for a novice like me was complicated to follow the code all the way through. THank you for your help on this though it is much appreciated.

Hi PBaldy. Sorry to sound thicker than thicker but when you say use the .text property do you mean in the query design itself itself. Use your method for all my comboboxes and they work fine but cant seem to refine this one. Am i struggling becuase i have 4 columns in the lstbox?

Hi MajP Not quite as straight forward as i thought!!! Look forward to seeing if you find that other class for all the fields. Cheers

Hi. Im trying to have a form with a text box in and a listbox. As i type in the textbox i want it to filter the lstbox according to what is typed in the textbox. (image of form attached) Struggling on 2 fronts - 1. I have in the change event of textbox a requery command Private Sub...

Hi CJ. THanks very much. That helped alot and now allows me to do what i wanted to achieve.

I have a continuous form with all of the comboboes and textboxes bound to a field in a table. I have a combobox for choosing the category and when i choose the category it filters down my options in my variety combobox to only those within that category. Works fine. If i change the category...

Hi RIdders. THink i have sorted it by deleting the joins between cateroy table and genus table and genus table and variety table. What i am not sure of is why i had to do that?

Hi. See image of the qry design. The table that makes it read only is Tbl_Genus. BOttom left corner.

Further update. I have found the cause of the problem. Just not the why it is causing the problem. I have a qry that forms the datasheet. This qry uses multiple tables. Yesterday i added an additional table so i could add genus to the datasheet. As soon as i do this delte is no longer an...

Hi I have a main input form which i enter all my production batches on. Within the form i have a subform that shows each entry as i input them. ONce i have inputted the weeks entries i double check eac hdata entry and then when im happy i click upload data. (see image). Only at this point...

Hi BOth. Yep that fixed it. Minty - double quotes not required like you suggest. Thanks for sticking with me on that one. Delimiters confuse the hell out of me. find it hard to follow them through. THanks again

OK SO tweaked code as noted id made couple of erros. Tbl_Variety didnt have category id in it so changed that to Qry_Variety and added the letters ID to IntCategory in the dcount line of code Dim strVariety As String Dim IntCategoryID As Integer strVariety =...

CLose but no cigar. Now get the following error attached.

Hi Minty tried the code and get error pop up saying syntax error. Any ideas

Hi Ridders, apologies i said Minty instead of you. THanks to you both for contributing so far.

Hi Minty that worked a charm. Many thanks. I went with the following code you suggested Dim strVariety As String strVariety=Me.Cbo_Tier3.Column(1)) If DCount("Variety","Tbl_Variety", "Variety = '" & strVariety & "'") = 1 Then Question is how i now add the qualifier that it needs to also...

As with all the code i write i try to start simple and then build to what want so to start with i was just trying to check whether there was more than 1 variety in total across the total tbl_variety and then i was planning to add in the check to limit it to the particular category i had selected...