473,322 Members | 1,614 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Listbox - Requery

All

I have a listbox in a form footer. When the form footer is visible the
listbox requeries fine but when I turn the form footer visible=false
the listbox does not requery at all. What I am trying to achieve is to
change the listbox's rowsource, as I said this works fine when the form
footer is visible but then nothing happens when the form footers is
invisible. I know the rowsource is changing in the listbox but it
doesn't requery. The funny thing is that when I try moving the
listbox to the form details and even if the listbox in invisible all
works fine the problem is when the listbox is in the form footer and
the form footer is invisible.

for reference this is the code I'm using to change the listbox's
rowsource

Select Case Me.txtCategory
Case Is = 1
Me.lstCategory.RowSource = "SQL....
Me.lstCategory.Requery
Case Is = 2
Me.lstCategory.RowSource = "SQL....
Me.lstCategory.Requery
Case Is = 3
Me.lstCategory.RowSource = "SQL....
Me.lstCategory.Requery
End Select

Any suggestions on how I could solve this problem?
Thanks in advanced

GAVO.

Jul 25 '06 #1
1 4010
What are you trying to accomplish by requerying something you can't
see? Is the information used elsewhere? Is there a reason it needs to
be on the form footer? There may be a more practical solution if more
information is presented.
ANDRESUK wrote:
All

I have a listbox in a form footer. When the form footer is visible the
listbox requeries fine but when I turn the form footer visible=false
the listbox does not requery at all. What I am trying to achieve is to
change the listbox's rowsource, as I said this works fine when the form
footer is visible but then nothing happens when the form footers is
invisible. I know the rowsource is changing in the listbox but it
doesn't requery. The funny thing is that when I try moving the
listbox to the form details and even if the listbox in invisible all
works fine the problem is when the listbox is in the form footer and
the form footer is invisible.

for reference this is the code I'm using to change the listbox's
rowsource

Select Case Me.txtCategory
Case Is = 1
Me.lstCategory.RowSource = "SQL....
Me.lstCategory.Requery
Case Is = 2
Me.lstCategory.RowSource = "SQL....
Me.lstCategory.Requery
Case Is = 3
Me.lstCategory.RowSource = "SQL....
Me.lstCategory.Requery
End Select

Any suggestions on how I could solve this problem?
Thanks in advanced

GAVO.
Jul 25 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Annette Massie | last post by:
I would like to have a form that lists current addresses being used. On this form I would also like to have a command button that would allow the user to add an address if they do not see it...
4
by: Kyralessa | last post by:
In Access 2000, I have a base form with a ListBox of conference registrants. In the form's declarations section I include Dim f as Form To add a registrant I'm doing this: Set f = New...
1
by: M Wells | last post by:
Hi All, I am developing an Access 2003 project application with the back end in SQL Server 2003. I have a master form that tracks projects, and several subforms on it that track various...
4
by: N. Graves | last post by:
Hello... thank you for your time. I have a form that has a List box of equipotent records and a sub form that will show the data of the equipment select from the list box. Is it possible to...
9
by: Megan | last post by:
Hi- I'm creating a database of music bands with their cds and songs. I'm trying to program an SQL statement so that I can enter a string of text in a textbox, press the 'Enter' key, and have...
6
by: Mark | last post by:
Hello. I have a listbox whose rowsource is set to a saved query (call it "qry_customer_list.") When I add customers to my database, I call the listbox Requery method so that the listbox will...
6
by: MarkoBBC | last post by:
Hi everyone, First a brief description of my form: I have a subform within a main form. In my subform, I have a listbox displaying address information by firm name. A user first has to select a...
1
by: melvincwmah | last post by:
I have a form in which I would link the form fields to tables in the SQL database. Right now, I want to put in a listbox that will show three columns from a table called IssueAudit. The...
6
by: binky | last post by:
Good afternoon folks, I have a performance question if anybody might have suggestions. Functionally, everything i'm about to describe works as intended. The only problem I'm having is speed. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.