multivalue fields

[Edward]

In use the follwoing code in a combox Roe source on a form
SELECT [Session].[Session_ID], Session.Session_Date & " , " &
Session.Session_Time FROM [Session] ORDER BY [Session_Date], [Session_Time];
which shows date and time in the combox box
I wanted to add new field which is mutivalue field ( field name is Session
same as the table name)

SELECT [Session].[Session_ID], Session.Session_Date & " , " &
Session.Session_Time & " , " & Session.Session FROM [Session] ORDER BY
[Session_Date], [Session_Time];
when i use this code combo box is empty and nothing shows , I can add any
other field but this one so i don't know this is because its a mutilvalue
field or because its name is the same as the table name or any other reason?

 

[Wayne-I-M]

Copy your table

Copy your form

Base the new form on the new table

Change the name of the field

See if it works

If it does - thats your problem

If not - post back

 

[Edward]

I did change the field name and still have the same peoblem I can show all
three fields in the combo box , but when I make a selection it will only show
the first field, so that's why I had to use & to combine those three fields
..By doing this not only I can see all three fields in the combo box but also
when I make a selection I want to see them in combo box text .It seems it
works with any combination of three or more fields but not working with a
filed that has mutil value. Any thoughts?
--
Best regards,
Edward

Copy your table

Copy your form

Base the new form on the new table

Change the name of the field

See if it works

If it does - thats your problem

If not - post back

--
Wayne
Trentino, Italia.

In use the follwoing code in a combox Roe source on a form
SELECT [Session].[Session_ID], Session.Session_Date & " , " &
Session.Session_Time FROM [Session] ORDER BY [Session_Date], [Session_Time];
which shows date and time in the combox box
I wanted to add new field which is mutivalue field ( field name is Session
same as the table name)

SELECT [Session].[Session_ID], Session.Session_Date & " , " &
Session.Session_Time & " , " & Session.Session FROM [Session] ORDER BY
[Session_Date], [Session_Time];
when i use this code combo box is empty and nothing shows , I can add any
other field but this one so i don't know this is because its a mutilvalue
field or because its name is the same as the table name or any other reason?

 

[Wayne-I-M]

Have you set your column widths to something other than 0 ????


--
Wayne
Trentino, Italia.

I did change the field name and still have the same peoblem I can show all
three fields in the combo box , but when I make a selection it will only show
the first field, so that's why I had to use & to combine those three fields
.By doing this not only I can see all three fields in the combo box but also
when I make a selection I want to see them in combo box text .It seems it
works with any combination of three or more fields but not working with a
filed that has mutil value. Any thoughts?
--
Best regards,
Edward

Copy your table

Copy your form

Base the new form on the new table

Change the name of the field

See if it works

If it does - thats your problem

If not - post back

--
Wayne
Trentino, Italia.

In use the follwoing code in a combox Roe source on a form
SELECT [Session].[Session_ID], Session.Session_Date & " , " &
Session.Session_Time FROM [Session] ORDER BY [Session_Date], [Session_Time];
which shows date and time in the combox box
I wanted to add new field which is mutivalue field ( field name is Session
same as the table name)

SELECT [Session].[Session_ID], Session.Session_Date & " , " &
Session.Session_Time & " , " & Session.Session FROM [Session] ORDER BY
[Session_Date], [Session_Time];
when i use this code combo box is empty and nothing shows , I can add any
other field but this one so i don't know this is because its a mutilvalue
field or because its name is the same as the table name or any other reason?

 

[Howard Burgman]

In use the follwoing code in a combox Roe source on a form
SELECT [Session].[Session_ID], Session.Session_Date & " , " &
Session.Session_Time FROM [Session] ORDER BY [Session_Date],
[Session_Time];
which shows date and time in the combox box
I wanted to add new field which is mutivalue field ( field name is Session
same as the table name)

SELECT [Session].[Session_ID], Session.Session_Date & " , " &
Session.Session_Time & " , " & Session.Session FROM [Session] ORDER BY
[Session_Date], [Session_Time];
when i use this code combo box is empty and nothing shows , I can add any
other field but this one so i don't know this is because its a mutilvalue
field or because its name is the same as the table name or any other
reason?

 

[Edward]

yes i did colum width is 0",4" to hide the Primary key but show the
combination of other fields.
--
Best regards,
Edward

Have you set your column widths to something other than 0 ????


--
Wayne
Trentino, Italia.

I did change the field name and still have the same peoblem I can show all
three fields in the combo box , but when I make a selection it will only show
the first field, so that's why I had to use & to combine those three fields
.By doing this not only I can see all three fields in the combo box but also
when I make a selection I want to see them in combo box text .It seems it
works with any combination of three or more fields but not working with a
filed that has mutil value. Any thoughts?
--
Best regards,
Edward

Copy your table

Copy your form

Base the new form on the new table

Change the name of the field

See if it works

If it does - thats your problem

If not - post back

--
Wayne
Trentino, Italia.



:

In use the follwoing code in a combox Roe source on a form
SELECT [Session].[Session_ID], Session.Session_Date & " , " &
Session.Session_Time FROM [Session] ORDER BY [Session_Date], [Session_Time];
which shows date and time in the combox box
I wanted to add new field which is mutivalue field ( field name is Session
same as the table name)

SELECT [Session].[Session_ID], Session.Session_Date & " , " &
Session.Session_Time & " , " & Session.Session FROM [Session] ORDER BY
[Session_Date], [Session_Time];
when i use this code combo box is empty and nothing shows , I can add any
other field but this one so i don't know this is because its a mutilvalue
field or because its name is the same as the table name or any other reason?