Combo box to list recordset

[jpr]

Hello,

I have a table with the following fields:
FATHERFIRSTNAME
FATHERLASTNAME
CHILDNAME1
CHILDNAME2
CHILDNAME3
CHILDNAME4
Is there a way I can list the above records using a combo in a way like
this :
PAUL SMITH (FATHERFIRSTNAME + FATHERLASTNAME)
JOHN SMITH (CHILD1)
MARY SMITH (CHILD2)
LOUIS SMITH (CHILD3)
ELENA SMITH (CHILD4)

I know that crosstab queries only allow 3 colums therefore was looking
for some way to bypass the problem.

Thank you.

[Joe]

Dear jpr

First thing you need to do is create a unique identifier field. Create
a new field in the first column preferably. Either craft you own unique
idenifiers or set it to autonumber. Once loaded with unique values make
this field the primary key.

Now you are ready to use the combo box using the wizard. It will give
you the option of showing various number of columns and automatically
hiding the new primary field created above.

If gives you the option of adjusting the widths of the columns.

That should do it

From Joe
jpr wrote: Hello,

I have a table with the following fields:
FATHERFIRSTNAME
FATHERLASTNAME
CHILDNAME1
CHILDNAME2
CHILDNAME3
CHILDNAME4
Is there a way I can list the above records using a combo in a way like
this :
PAUL SMITH (FATHERFIRSTNAME + FATHERLASTNAME)
JOHN SMITH (CHILD1)
MARY SMITH (CHILD2)
LOUIS SMITH (CHILD3)
ELENA SMITH (CHILD4)

I know that crosstab queries only allow 3 colums therefore was looking
for some way to bypass the problem.

Thank you.

[jpr]

thanks.
yes, I am aware of this function, but the problem is that I need to see
my recorset displayed in rows.

[Joe]

jpr

I guess I don't understand what your problem is.
The combo box will show the record set in rows.

I think you need to clearly define what you problem is

Joe

[Joe]

Joe wrote:

jpr

I guess I don't understand what your problem is.
The combo box will show the record set in rows.

I think you need to clearly define what you problem is

Joe

I just tried doing what you want to do.

I think you problem is when you click on the combo box
you want the combo box to show the entire record set.
If that is you problem let me know

Joe

[jpr]

Sorry, you are correct. I did not express myself correctly.
I will try to better explain.
My table has 5 fields:

Father, Mother, Child1, Child2, Child3, Child4, Child5

I have created a form on which I need to place a combo which will
display in different consecutive rows the above records so that when I
click on the cbo data will be displayed not in one row so to reflect
the recordset, but in different rows, meaning each record in a
different row: This is how I would like to to show up:

Father
Mother
Child1
Child2
Child3
Child4
Child5

This is important because users will select the record using the cbo.

Is there a way this can be done? Appreciate your help. Thanks.

[Joe]

You need to break this down into at least two sub desgin goals
#1) show the results
#2) navigate to the results using the combo box
Set aside your concerns on the combo box
Concetrate on #1 goal

#1) You need to build a form that will display the results.
#1.a) Inorder to do that you need to build a query or table that will
display
the results.
#1.b) read up on how to create a form bound to the results of #1.a)

Only after you have completely solved #1 can you move onto #2

Hope this helps
Joe