Search results

Hi Ranman256, thanks for your quick response, the SQL works, I made it with the Query builder and then I copied from the SQL view. This is ok. The problem is rewriting exactly the same for VBA. I don't know how to rewrite the bold part. the second combo has a list like: A112, B324, B114...

Dear all, a simply simply question...that is taking me hours! This is the SQL sentence from a Query in a combo (which is filtered for another combo, nothing special, letting only the values with the first letter in that combo). How can I write it for VBA???? (Please, indicate all the ", I...

Yes, maybe I did not explain it well. I do not want to filter a subform from the mainform: I want to filter the main form, restrict it only for some registers, using a user-password dialog-form. I found the solution in the allenbrown site I wrote in the last post. Dim sSQL As String sSQL =...

Yes, that is true, but it is not what I am looking for...or what I am looking "form".. The combo filter the form and goes to that record, but the rest of records are available. What I need is to restrict the form, only a few records will be accessible. That can be done, as far as I know, with...

Hi James, thank you very much for answering. The combobox for the record lookup goes to the record that fits with the condition, only one, but also all the rest of records are still available (from the record selector at the bottom of the screen, for example). In my case I need to restrict the...

Hi, I am trying to write a "[Forms]![Nameform].Filter =" a little bit more complex... I need to filter a Form (Orders) in order to let a User only to access to his/her own orders. Tables "Orders" and "Users" are linked by a many-to-many intermediate table, "OrderUser" (with only three fields...