ComboBox, ListBox or something else

[SSUTTON]

Hi: I am working on a database that is going to contain families involved in an organization I am with. My form is a tabbed control with 5 tabs on it and is set to continuous. One of the tabs is titled "Children".

This is my question:

When a family has more than one child I would like to be able to display all of their information in the tab at the same time with columns for Firstname, last name, Date of Birth and MCP Number as headings. Should I use a list box, combobox or is there any other way I can do this and have all of this information for a given family to display at once in it's assigned tab?



Thank you.

[amrut]

Listbox is alright if this is only for display. You have to set the listbox rowsource every time the record changes. Do not know your data structure, but a sub-form is ideal for this kind of info (Parent-child relationship) with separate tables for parents (Main form) and children (sub-form))

[SSUTTON]

There are times when things may need to be edited. If a child no longer lives at home - old enough to be on their own.

[amrut]

Hence sub-form is best suitable so you do not need any code to fill the list box and easily add/remove/edit the children

[orange]

ssutton,

Could you please expand the description of WHAT you are trying to do? Plain English please.

This is a start

I am working on a database that is going to contain families involved in an organization I am with.

but you have jumped into HOW too quickly and readers are missing some details.

A jpg (screen capture) showing your tables and relationships would help with context.

Good luck.

[SSUTTON]

I am working on a database that is going to contain information about families involved in an organization I am with.I have figured out how to create the listbox and I have it created. My problem now is that when I right click and pick Edit List Item from the list.. It seems like nothing happens. I have given you a screenshot of my design. I tried to upload my database but the file size is to big to upload here. Sorry! Any ideas of what property I should be looking at on hte Listbox Property sheet to correct this. Or do I just do it through the additem vbacode? Thank you.

[orange]

Database designs would normally start with a set of requirements; then build a data model of the "things" involved in the proposed application based on the "business" facts.

Here is a free data model which identified the tables involved in a typical Family Hierarchy.

It should get you back on track.
Good luck with your project.

[SSUTTON]

I actually did get my list box structure designed. Now I am working on Buttons for my forms and I am going to use the button wizard for that. Thanks for your help