Retrieving tag property - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Retrieving tag property

David Campbell

2 years ago

On my form_open access object to populate a combo box with reports I am having trouble getting Tag property to use as a second criteria after description <>"" to select which reports go to which form

	Ludwig Willems @Reply 2 years ago
volgen :)

	Alex Hedley @Reply 2 years ago
What code did you try?

David Campbell OP @Reply

2 years ago

I modified the code from Richards  video

Private Sub Form_Open(Cancel As Integer)

    Dim AO As AccessObject, Description As String

    On Error Resume Next
        For Each AO In Application.CurrentProject.AllReports
            Description = ""
            Description = CurrentDb.Containers("Reports").Documents(AO.Name).Properties("Description")
            If Description <> "" Then AccountReportList.AddItem AO.Name & ";" & Description

        Next

Added T as string then set T to "" then went through mimicking Description with properties was unable to get the tag property

	David Campbell OP @Reply 2 years ago
Placed a msgbox to view tag and even though tag had data showed nothing added in If statement AND T = Finance then do the add item

	Alex Hedley @Reply 2 years ago
What settings does `AccountReportList` have? If memory serves it has to be one not the other to be able to add an item like that.

	David Campbell OP @Reply 2 years ago
AccountReportList is name of the combo box

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View