multivalue fields

  • Thread starter Thread starter Edward
  • Start date Start date
E

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?
 
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
 
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


Wayne-I-M said:
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.



Edward said:
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?
Click to expand...
Click to expand...
 
Have you set your column widths to something other than 0 ????


--
Wayne
Trentino, Italia.



Edward said:
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


Wayne-I-M said:
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.



Edward said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Edward said:
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?
Click to expand...
 
yes i did colum width is 0",4" to hide the Primary key but show the
combination of other fields.
--
Best regards,
Edward


Wayne-I-M said:
Have you set your column widths to something other than 0 ????


--
Wayne
Trentino, Italia.



Edward said:
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


Wayne-I-M said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top