Combo Box orList Box

[dbmanalser84]

I've build a rather complicated database about a Car Shop. Now its time to enter some data in it, and I want to build forms to do this first. Here are data of the first table I want to enter data:

tblCars
#intCarID
intManufacturerID
txtModelName
dteAssemblyDate
intModelPrice

tblManufacturer
#intManufacturerID
txtManufacturerName
.... there is some other data which is irrelevant at this point.

Now, I want to create form for tblCars where instead of entering Manufacturer ID as a numerical value I want to select Manufacturers by name from the tblManufacturers and enter that selection in tblCars as numerical value.

Is it better to do this via Combo Box or List Box and why? What is the difference between the two?

Between the two options (save for later use and store in this field) which one should I choose? Can someone explain these two optins better?

Can I delete the Primary Key field from the form? Will it update automatically when new data is entered if its not displayed on the form?

Thnx.

 

[DCrake]

Simple Software Solutions

Hi

There are pros and cons for each type of control. Alot depends on how busy your form is. With combo boxes as you type in the name the combo tries to match up an entry in the list. So as you type in the list gets smaller until you find your entry. However with list boxes they only respond to the first letter, so if you hit the C key it will move to the first item in the list beginning with C, then if you type in R it will move to the first item beginning with R not the first item beginning with CR.

List boxes do have their good points as it is easier for the end user to use and locate visually the item they want.

I suggest you read up on the pros and cons of each control and make a descision based on the contents of the form and how you want the control to operate.

CodeMaster:

 

[dbmanalser84]

Ok..

Ok, I'll use a combo box because it looks like selection menu and doesn't take too much space, but what about my other questions?

Also, I want to create links on forms to other forms, I done that sucessfully but I want to add a fancy rollover effect like HTML Hyperlinks have, can I, and how, do that? My links to other forms are simple Lables.