Recent content by TheSearcher

@Tom - Yes I know. My mistake. @moke123 - Good idea. Thanks.

I mistakenly was trying to clear a label. Interestingly, a label does have a tag property - but I guess it can't be used for this. Thanks tvanstiphout.

I've been using the following code for the past twenty years. A few minutes ago I started getting an "Object doesn't support this property or method" error on the ctl.Value = null line. Any ideas? Dim ctl As Control For Each ctl In Me.Controls If ctl.Tag = "clear" Then ctl.Value = Null Next

It is a field called Note_Id. I should also mention that "male" and "female" along with the names of the recordsource queries are not the actual names. I made them up so that my question could be more easily understood. To describe what I was encountering using the actual names would have been...

They have the same fields but not the same data. The common field is called "Options" but the data for male and female options differ.

I succeeded by placing the code in the "On Activate" event of the parent report.

If txt_Sex on Main Report = "M" then I want the recordsource of Subreport1 to be q_Male else q_Female. If Parent!txt_Sex = "M" Then Me.RecordSource = q_Male Else Me.RecordSource = q_Female End If Is this the correct code? Do I place it in the subreport? If so, on which event? Any...

Good advice as always. I will do that. The problem was in my Insert query. A space where it shouldn't be. For Each varitm In lst_Modalities.ItemsSelected sql1 = "Insert into tbl_Note_ST_DDD_Modalities (Note_Id, Client_Id, Client_Name, Modalities) " sql1 = sql1 & "select " &...

@MajP - As you suspected, there was a space at the end of the strings. That's why it wasn't working. All is good now. Thank you very much for your help!

@MajP - Thank you for your help. I will try everything you suggested. I just reran the code. The code seems to be looping as it should but the matches don't get selected. There are 18 options and two that have been selected. See below. List Value: Tactile selection Seleced: Tactile selection...

Correction - The NEXT is working. It sems to be the rs.movenext that's the issue.

@MajP - 2 problems: The first match "Referential signaling" doesn't get sent to True. The second issue is that "Referential signaling" is one of 18 possible options - but it never gets to any of the other options. It appears as though the NEXT isn't working. List Value: Referential...

Hi All, I use the following code in many different applications to display what has already been selected from a listbox while opening a form. It always works perfectly. However, in this particular instance, all listbox values remain unselected. This code is on the On Open event of my form. Can...

Ron Paii - You are the man!!! Works perfectly! Thank you!!!

Thank you. Much needed article! So, the Start_Time and End_Time displayed in the snapshot of my table above is not an accurate representation of the data stored in that field. That's just wonderful! Is there anyway to get Access to display what is truly stored in the fields? This would be very...