combo list

[kasa74]

Hi all,

I am making changes to an access database. I want to add a new combo list to a form and I want the new combo list to store its data in a table that other combo list in the form are storing their data for each client. What do I do first, do I add a new field to the table. After adding the combo list to the form, what do I do next.

thanks

 

[Uncle Gizmo]

>>>do I add a new field to the table<<<<

I take it you mean add a new field to store the data that you want to display in the combo box, if that's the case then no!

However if you add a new field which identifies the data in the existing column as belonging to one combo box, let's say you have a combo box that displays "subjects" you would use the new field to hold the identifier "1" for each entry that was a subject.

Next you may wish to store "teacher name", you may want to identify this with a "2" and then whatever else you want to store identified with a unique identifier.

In your combo box you set up the properties to filter and display only the relevant data to that combo box.

You now have one table for storing lookup information which is a good idea in my opinion, you can also now have just one form for editing this data, just filter on the number as described above.