Recent content by Irie

Dale, The code should go in the on_click property of the commad button. HTH

Dale, Have you tried using code to requery instead of a macro? Firstly, where is the button that you use to update your subform. You must make sure that you reference the requery right if you have the button on the main form. [Forms].[mainformname].[subformname].[textboxname].requery To...

I would suggest having a listbox that enables the user to pick the criteria for the search. So the user can select "Mondays" and "CPR" or "Mondays", "Saturdays" and "MilitaryClearance". Basically any combination...... This is code from R.Hicks that will enable you to get the criteria from the...

Thanks for the reply Shacket.... Your suggestion works to the point that the first value is displayed in the combobox, but all the other txtboxes remain blank. I got it to work by combining two comboboxes that I had, that were each based on a seperate query. I then just combined the queries...

I have a combobox, which has many columns, and depending on what value I select in this combo it brings up relevant information in other txtboxes. How do I get the first value to appear in the combobox, and have its related txtboxes already filled with the related information? Basically...

Thanks Drew for the Code... I managed to get it partially working, I am now trying to get it to work for all my forms. Thnx Again, Irie

Drew, I have attempted to use what you suggested, but I am unclear as to how I should call the function. Could you show me the code for this... Thnx

Doug, I think I have done the code correctly, but could you check what I have, as I am getting errors.... Dim form1 As String, form2 As String form1 = "search" form2 = "renewalform" While fIsLoaded(form1) Or fIsLoaded(form2) DoEvents Wend If fIsLoaded(form1) Then Forms![entryform].Visible =...

Doug, One last question? How can I duplicate your code so that it will check to see if two different forms are open? Do I need to create a new function for the other form? Say: Function fIsLoaded2(ByVal strFormName2 As String) As Integer 'Returns a 0 if form is not open or a -1 if Open If...

Doug, THANK YOU, THANK YOU.... Absolutely Brilliant!!!! One less problem thats been buggin me for weeks. Thnx

ok, it looks like I had better give the full explanation...... I have a form which is based on a query. The purpose of this form is to see what licences are coming up for renewal. So when a user launches the renewalform from a mainform, they are prompted to enter the Month and Year they wish...

DjBummy, YOur suggestion works if I have originally arrived at the record form from the searchform. But if I arrive at the recordform directly from the mainform. Then I get an access error stating that the searchform is not open. So my question is.... Is it possible to create an IF statement...

Thanks Doug for the code, I am trying to incorporate the idea of using the tag into my code. If anyone else has a suggestion or comment please reply, Thnx

Denny, Thanks for the suggestion. I have thought about what you have said, and have realised that it could work. But the main problem though, is how do you pass on the information to the report, and the form at the same time? Does anyone else have any suggestions? Comments? Thnx

Using a button on a form, I use the following code to dictate what records appear in the report, basically whatever records are on the form. DoCmd.OpenReport "renewalreport", acViewPreview, , "[Renewal]=Forms![Renewalform]![Renewal]" My problem is that the form is a continuous form and...