Search results

I normalized a couple of things and cascaded them to what I think you are going for. Check the relationships, combo box data sources and the code behind the City combo box to see what I did. HTH, -dK

If I get this right, your report runs and you want ... Accountants Acct Name1 Acct Name2 Doctors Dr Name1 Lawyers Lwyr Name1 Lwyr Name2 If this is correct, why not just use the grouping levels on the report and not worry about an If to present these for you? -dK

The link I gave you uses the properties of the forms .Filter property. Once you have the query constructed, it will populate the form and then it will be filtered according to the form control inputs. -dK

Try that in the AfterUpdate event of the unbound text control (Text0). -dK

Hoopty! Just checking in .. what was the final solution? -dK

Check to make sure it is a label control you put on the form and not a text control. -dK

You can use the DoCmd.MoveSize function to set the parameters of the position. -dK

Needed a comma here ... DoCmd.Close acReport, "RptIncidents", acSaveNo Anyhow, I jumped in here thinking of some possibilities where this could be used for myself. -dK

Okay, think I am with you now. Here is how I have overcame this before using pop-ups in this manner. Create a label control and set it where you want the 'message' to appear. Say call it lblMessage. Then on the OnLoad event use ... If IsNull(Me.OpenArgs) Then Me.lblMessage.Caption =...

Creating some .. well .. what appears to be some circular referencing. You have ... Private Sub Broker_Involved_AfterUpdate() Call Me.Broker_Involved_AfterUpdate End Sub Try ... Private Sub Broker_Involved_AfterUpdate() If Me.Broker_Involved = True Then Me.cboComboBoxName.Enable = True...

Was curious so dropping on the eaves of this thread. Since I had a test db open - I checked it and the requery method works (made some field level data changes) except when you add the reference from the report control (Forms!frm!cnt) to the form control to update the comments field. -dK

Amen! It's definitely going down in my book. I am trying to withhold myself from going through a buncha stuff to see if I can implement right away. :D I am sure someone will want to add something new at which point I can take advantage of it. -dK

Nice nugget there, Bob. Who'da knew? krzysiekk, I just validated this using Bob's post and added a label for visual verification. I added this code on the OnCurrent event of the form so I could cycle through records to see the label caption change as I modified the end time ... Notice that...

You could copy and strip out the unnecessary bits. As an aside, I've posted what I did - perhaps you can do a bit of stare and compare to contrast what I've done verses what is going on in yours to see if anything is amiss. -dK

I've attached a report screen and the original proposed solution appears to work. The first two columns (A & B) are bound and fed from a table. Column X & Y are unbound and calculated (e.g., [A] + 2). Last, column Z is unbound using the IIF in discussion. Perhaps you can post the db? -dK

Ah .. found it. This might be overkill for what you are doing, I am not sure of your underlying structure, etc., but you should be able to get the gist of it. Take a look at this thread. You would definitely have to mod the WHERE statement in the function posted by VBAInet (post #11). The...

Okie dokie ... I have my method of doing it but discovered another way that was posted not too long ago that might be of better assistance. I will have to search through the forums for the appropriate thread - give a few moments ... -dK

Okay ... to surmise so I can stall for time and think :D The IIF is used in a control source of an unbound control in report? The controls referenced [textn]are calculated controls (based on other controls) or are they bound controls (coming from an underlying table/query)? -dK

Errrr .... I was using that as a demonstration that you should be able to use Me.OpenArgs anywhere in the pop-up. :o Now, if you want (because you instantiate other forms using the function) you can set up a (public) variable and assign that variable the contents of OpenArgs for use or...

Hmmm ... that 5|2 definitely doesn't compute. Just for grins ... modify your IIF to this ... IIf(CInt([text1]) > 0, CInt([text2]) - CInt([text1]), CInt([text1]) + CInt([text2])) -dK