Cant get my Login form to display items in a list box

[RoyLittle0]

Hi,



I have been following a Tutorial from mrexcel forum but I cant seem to get it to work, I am obviously doing soothing wrong but for the life of me i cant see what it is

http://www.mrexcel.com/forum/microso...ns-system.html

I have two text boxes txtUser and txtLevel (these would normally be hidden) and they are getting the correct information from my login

These then look at the MenuItems and if the txtLevel is greater than or equal to the value in the table it will display that line and therefore give access to the form (no forms added at the moment)

any help would be appreciated

Service Asistance Logging.zip

[June7]

Change the listbox RowSource by removing the reference to form prefixing the textbox name:

SELECT MenuItems.Item, MenuItems.Form, MenuItems.ObjectType FROM MenuItems WHERE (((MenuItems.Level)<=txtLevel)) ORDER BY MenuItems.SortOrder;

[RoyLittle0]

Ok, if I load the form then all items show in the listview which is incorrect

but if I change from FormView to DesignView and then back to FormView again, it works, so it must be something to do with the form load, or the data in the listview is loading before the form load routine has finished?

But the query itself seems to work.

[June7]

Add this line at end of the form Load event:

Me.lstMenu.Requery

[RoyLittle0]

Perfect, Thank you