Combo-box order and Form backgrounds???

[Rosscoah]

I have just created a combo box to list and select all of the records in my database so they can be selected quickly, however for some reason the list is not in the correct order.

I have been back to the table and sorted all of the records into ascending order based on the field that is being used in the combo drop down box, but it is still not correct.

There must be an easy way to put them in order. Do i need to change the primary key so that it corresponds the field i am using to search or is it more comlicated than this??

Also, I created a form using the form creation wizard and now i have a grey stone background that i would like to get rid of. How do i do this? There only seem to be 9 or 10 pre-made formats to choose from?

Thanks in advance

 

[gemma-the-husky]

1. base the combo box on a query, and sort the query as you want it.

2. change the image on your form. in form properties, select a picture, embedded probably, and a layout types (stretch/zoom etc)

note that you can get a lot of Access bloat with embedded images, and anything other than pastel backgrounds looks pretty nasty.

to change all your forms means a bit of code, as you have to do this in design mode, not runtime.

 

[Rosscoah]

1. base the combo box on a query, and sort the query as you want it.

2. change the image on your form. in form properties, select a picture, embedded probably, and a layout types (stretch/zoom etc)

note that you can get a lot of Access bloat with embedded images, and anything other than pastel backgrounds looks pretty nasty.

to change all your forms means a bit of code, as you have to do this in design mode, not runtime.

Thanks Gemma, I tried the query method and it has put the list in order, however, now when i select the required record form the dropdown box nothing happens. The selected record is not displayed on the form only the number in the box changes.

Any ideas?????