Recent content by Mikezy56

I have declared a public variable thus :- ############################################ Public MasonicOrder as integerMasonicOrder=1 @ The default value ############################################ In Module 1 of my VBA for Access. Can I type :- #############################################...

Can I use a global variable as a parameter in a query please:(:(:(:(:(:(

Michael I guess that I need to change the string names in that API to reflect my field names. Is that correct?

Thank you Michael it will take me a while to absorb that but I am now much more hopeful of resolving this issue based on your code.:):):):):):)

Thank you Michael I tried that the snippet now looks like this ################################# Private Sub Combo7_AfterUpdate() On Error GoTo Err_Command13_Click Dim stDocName As String Dim chosenorder As Integer strDocName = "frmChooseUnit" chosenorder = Me!Combo7.Value...

Michael Is this the way to send it please? # Dim stDocName As String Dim chosenorder As Integer stDocName = "frmChooseUnit" chosenorder = Me!Combo7.Value DoCmd.SetParameter "qryunits!chosenorder1", chosenorder DoCmd.OpenQuery qryUnits, acViewNormal, acReadOnly...

I am going blue in the face trying to set the parameter "chosenorder1" and pass it into form frmChooseUnit. Then open the form . The form is based upon a query called qryUnits. I am sure this should be very easy but it just does not work for...

I am Mike ZY56 I am 68 years of age and have some limited access exprience but am returning to it after a gap. I live just outside London England. I hope that is enough of an intro:confused: