switchboard listbox problem

[tselie115]

hello everyone
im trying to add to my switchboard a listbox that lists all the existing records on the main form to choose one of the them and go straight to that records
im using the vba code:

if Not IsNull(Me.List0) Then
DoCmd.OpenForm "main", acNormal, , "ProjectID = " & Me![List0].Value
End If

it works fine when i do it on a normal form but on switchboard form i m not able to select the records from listbox it just doesnt select as if its blocked.
any solutions please?

 

[statsman]

You have it in one tselie. Switchboards are not really intended for this function. This is one of the reasons I rarely use switchboards.

Create a custom form to act as a menu and it should work fine.
OR
You could use the switchboard to open a search form for this function.