Alternative to Listbox?

[Loopster]

Hello

I am designing a database in which I have used a lot of listboxes sourced to tables. I need to run queries on the listbox results but this doesn't always work due to the listbox/query issue, (found on this forum).

Is there an acceptable alternative to listboxes as the only thing that I can think of is to use checkboxes which would make the data entry for the end user interesting? (The only way around this would be to have individual databases for each person, this defeats the objective of having a database...)

Many thanks

Loopster

 

[Simon_MT]

I find the combibox approach useful as you can easily update the underlying tables.

Two tricks I have learn.

1) On the combibox using a Module:

On Entry =LookupArtist()
On Exit =LookExit()

Function LookupArtist()

    With Screen.ActiveControl
        .RowSource = "SELECT ArtistsLookup.Artist, ArtistsLookup.[Artist Short] FROM ArtistsLookup;"
        Call ListDisplay
    End With

End Function

Function LookupExit()

'   Set to null when exiting control

    With Screen.ActiveControl
        .RowSource = ""
    End With

End Function

2) Some Tables have multiple combiboxes essentially with the same data type (char 1). So I throw all these Variables into one Table in a composite key, the second field is the Lookup Type. This way I don't have to have a table to every single permutation.

Some versions of Access when opening a form don't like the first field with this treatment so I just put a Tab Stop No on the field.

Simon

 

[Loopster]

Hi Simon

Thanks for this, it looks good. I'll work it into the database & see what happens - database development day is Tuesday so I won't be working on it till then

Much appreciated

Lucy

 

[Simon_MT]

If you need any help let me know. Anecdotally, I did this for performance reasons as the my Forms were just getting to complex and the combiboxes on demand sorted this out. I don't use VB on Forms everything is now within Modules.

Simon