I can't do what the wizard can!!

[Toby1kenobe]

I just can't get dorothy back to kansas.......sorry!!!

If I create a form using a wizard all the controls etc have the links to the underlying table set. How can i set up a list box that calls its information from 'Names' in the tables tblStudentInformation?. I've tried using the expression builder but without luck

Any help much appreciated
Thanks for your time
Toby

 

[Haitham]

Please Be More Clear.

 

[gusbrunston]

Hi, Toby:

The wizard should work: make sure the wizard is highlighted, then drag the list box icon to the place you want it on your form and size it (I prefer the combo box because it takes less room, and you can type in additional information.) Select "I want the list box to look up the values in a table or query." and complete the other choices in the wizard. You may end up with a bound or unbound list box.

The Row Source in the property sheet, Data, for the list box will display something like the following:

SELECT [tblStudentInformation].[Names], [tblStudentInformation].[FirstName], [tblStudentInformation].[LastName] FROM [tblStudentInformation]

(Personally, I'd want to rename "Names" to "StudentID".)

I for one, don't care to replace the wizard when he does such a good job with something like this.

I hope this is helpful.
Gus Brunston An old PICKer, using Access2000.