Unbound List box

[LindaBee]

I need help urgenly please.

I have a form with all the fields from my user table which has information
about users. I have an unbound list box in my form which displays some of the
fields in the form and have also created an unbound text box to search in the
list.

The list is populated by an underlying query. When I run the query in desing
mode is brings results but when I open teh form the query results are not
being displayed

Please someone help?

 

[bhicks11 via AccessMonster.com]

Hi LindaBee,

Can you give more information about your listbox. How are you referring to
the Query, is the SQL showing in the RowSource or a Query name? If so, try
creating the Query directly in the listbox. Post the SQL. Do you have any
events running in this listbox or the form that affect the listbox? What is
the relation of the unbound textbox?

Bonnie
http://www.dataplus-svc.com

 

[brlubman]

Hi LindaBee,

Can you give more information about your listbox. How are you referring to
the Query, is the SQL showing in the RowSource or a Query name? If so, try
creating the Query directly in the listbox. Post the SQL. Do you have any
events running in this listbox or the form that affect the listbox? What is
the relation of the unbound textbox?

Bonnie
http://www.dataplus-svc.com

 

[LindaBee]

Hi
I have created a query based on the table used as a data source for the form
here is the sql query. You will notice there is a fields called Search2.
Search2 is a text box source is the feld called ID which the search criteria
will be based on.

 

[bhicks11 via AccessMonster.com]

You didn't post the SQL.

Bonnie
http://www.dataplus-svc.com

Hi
I have created a query based on the table used as a data source for the form
here is the sql query. You will notice there is a fields called Search2.
Search2 is a text box source is the feld called ID which the search criteria
will be based on.

Hi LindaBee,

[quoted text clipped - 19 lines]

 

[LindaBee]

SELECT tbl_User.ID, tbl_User.LID, tbl_User.Fname, tbl_User.Sname,
tbl_User.[Job Title], tbl_User.[Section/Team], tbl_User.[Phone & Extension],
IIf([Actioned]=-1,"Edits Not Allowed",IIf([Actioned]=0,"Edits Allowed")) AS
Status, *
FROM (tbl_User INNER JOIN tbl_Network_Access ON tbl_User.ID =
tbl_Network_Access.[Person ID]) INNER JOIN tbl_Admin ON
tbl_Network_Access.NWID = tbl_Admin.NWID
WHERE (((tbl_User.Fname) ALike "%" & [Forms]![frmNewUserSearch]![Search2] &
"%")) OR (((tbl_User.Sname) ALike "%" & [Forms]![frmNewUserSearch]![Search2]
& "%")) OR (((tbl_User.[Job Title]) ALike "%" &
[Forms]![frmNewUserSearch]![Search2] & "%")) OR (((tbl_User.[Section/Team])
ALike "%" & [Forms]![frmNewUserSearch]![Search2] & "%")) OR
(((tbl_User.[Phone & Extension]) ALike "%" &
[Forms]![frmNewUserSearch]![Search2] & "%") AND ((tbl_Admin.Actioned)="%"))
OR (((IIf([Actioned]=-1,"Edits Not Allowed",IIf([Actioned]=0,"Edits
Allowed"))) ALike "%" & [Forms]![frmNewUserSearch]![Search2] & "%")) OR
(((tbl_Admin.Actioned) ALike "%" & [Forms]![frmNewUserSearch]![Search2] &
"%"))
WITH OWNERACCESS OPTION;

You didn't post the SQL.

Bonnie
http://www.dataplus-svc.com

Hi
I have created a query based on the table used as a data source for the form
here is the sql query. You will notice there is a fields called Search2.
Search2 is a text box source is the feld called ID which the search criteria
will be based on.

Hi LindaBee,

[quoted text clipped - 19 lines]

Please someone help?