Search results

You know, I have a form in which there are many records while the PartNo field is unique for each record. On the other hand there is a query with more details about PartNo. I want by clicking on a button (in the form), those mentioned details be shown only for the clicked record (which refers to...

vbaInet, sorry I didn't understand what is your exact question. :(

Dear Isskint, the code comes as follow: in the module: Public PartNo As String Public Function FilterPartNo() FilterPartNo = PartNo End Function ------------------ in the form: Private Sub txtPartNo_Click() Me.Refresh PartNo = [Forms]![frmCompareCurrentAndPreviousCondition]![txtPartNo] End Sub...

Hi, I defined a public variable and then for being able to filter a query results, assigned it to a public function. The problem is that function doesn't get the variable's value.:banghead: Any helps will be appreciated Thanks :)

Thanks a lot pbaldy. I found my mistake in that link you mentioned ===> the name of module and the function were the same. After changing one of the names, with Call FunctionName it worked. :)

How to run a function in a subroutine? Hi guys, I have a database which needs to be updated everyday. So I decided to make a subroutine to perform the update steps just by clicking on a button. :) The problem is that I can run all the steps except one!:banghead: At the end of the steps, there...