Tagging Records in a Continuous Form 1

[maxhugen]

In a continuous subform, I display records based on a DISTINCT query. Because it's distinct, each row does not include a record ID.

Does anyone know of a way to add a checkbox (or similar), so that a user can select any of the records, which will then be used to create new records via code?

I prefer to use a subform to a list, as it features lots of column sorting and filtering functions.

MTIA


Max Hugen
Australia

 

[PHV]

You may consider a command button (in the header or footer section of the subform) dealing with the current record's values.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[maxhugen]

True. However, I'd really like to have something like a pick list - check x number of records, then click a button to do the action.

Max Hugen
Australia

 

[PHV]

Either use a multiselect listbox or bind your subform to a temporary table.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MajP]

Use a listview, you can get a lot of functionality.

http://www.buygold.net/v03n12/v03n12.html

 

[MajP]

If you use the listview there are a few good faqs on this forum for loading and formatting.

 

[maxhugen]

Thanks MajP, it's probably as close as I can get to what I need.

Incidentally, do you know where to obtain a *working" copy of the help files for the ocx? I've tried cmctl198.chm and cmctl198.chi that I eventually found, but they don't work.


Max Hugen
Australia

 

[MajP]

No, but this is a good link

http://www.cgplusplus.com/online-reference/maxscript-reference/source/listview_activex_control.htm

 

[maxhugen]

Great, looks useful! Now to see if I can make sense of it all

Max Hugen
Australia

 

[MajP]

Make sure to read the following
faq702-6025
faq702-6026
faq702-6027

 

[maxhugen]

Hi MajP, the ListView control is working in most aspects, but I'm having an issue with the sorting. The code I'm trying to use is:

Private Sub ItemList_ColumnClick(ByVal ColumnHeader As ColumnHeader)
    ItemList.SortKey = ColumnHeader.Index - 1
End Sub

However, I'm getting a compile error "Procedure declaration does not match description of event or procedure having the same name."

Have you any idea what I might be doing wrong pls?


Max Hugen
Australia

 

[MajP]

ByVal ColumnHeader As Object
not
ByVal ColumnHeader As ColumnHeader

 

[maxhugen]

Thanks again, working AOK now! (I got that syntax directly from the Windows Controls Help File!)

Max Hugen
Australia