Recent content by Redfang87

To update my question, Im happy with the results im getting from this, if there is a better way great im all ears for trying other subform user filter methods, What I do need thought is for it to accept multiple filters without having to write out every possible combination in the above code...

So I have my form with a subform displaying open inspections, On the parent form I have text boxes and combo box's for user input's to filter what is shown in the subform. I have got this working as intended through the subforms select SQL but the method really doesn't feel like it is a good...

I couldn't get yours to work as it is , Im guessing because im not looking at any specific record in the table with the week constant but incorporating what you gave into the dlookup has worked perfectly. =DLookUp("((Left([Live_week],2)+1) &...

Im recording a week number as defined from a date as a constant in a table ( Live_week ) this is then used for reference through many areas, what Im struggling with is simply adding 1 to the week number so to show the current live_week I have a text box with...

Realised I had got myself tangled with this all I really need is something like this: SELECT Property.[PROP_ID], Property.[Number], Property.[Street], Property.[Area], Property.[Postcode] FROM Property Where Property.[Number] + Property.[Postcode] like [Forms]![Raise]![Add_Num] +...

Pretty new to access, Im trying to create a query that shows all the results that are like a forms input - The premise is I have a form for raising inspections - on submitting it checks the input address for possible existing records of inspections to that property - if none it inputs a new...