Form Combo Box Help

[lakelands]

Hi all...

I am having some real troubles with Microsoft Access 2000 on Windows 98...

I am trying to create a database with my friends first name, last name, email address, home phone and mobile phone numbers... I have been successful thus far, but i have struck an issue...

I am trying to create a combo box that, when i click down onto the select name, the persons information is displayed... However i want the names to be alphabetical instead of based on my primary key (FriendsID)...

If I base my form combo box on my table, the event procedure works and the information is displayed... However the names in the combo box are not alphabetical...

So then i created a combo box based on my query which shows last name then first name, sorted ascending in last name. However once this box is created, the information is not re-displayed.

I tried to alter the VB code to make it work, but i get an error...

Can anybody suggest a way in which i can alphabetically sort my combo box, with the information displayed, whilst still linking it to my table "Friends"???

Thanx - Maddogz

 

[SydneyGeek]

In Design view in the form, go to the Combo's properties and edit the RowSource. By clicking the Build button (...) you'll see the underlying query.
Say, for example, you have [FriendID], [LastName] and [FirstName] in the table. In the query, you need 2 fields: [FriendID] and a calculated field with the expression [LastName] & ", " & [FirstName]. Now go to the Sort row below this calculated field. Make it Ascending.
Close the query grid, save when prompted, and check (under All properties) that these are set correctly -- ColumnCount should be 2; BoundColumn should be 1; ColumnWidths should be 0;3 (the second value could be any non-zero number, I just use 3).

HTH
Denis

 

[lakelands]

Thanks got it together now