473,756 Members | 3,973 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 4032
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
3577
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 listed. Is it possible to have the form show the list box (which is a combinination of the address and city/state/zip), along with the detail fields address and city/state/zip? I guess I was thinking of have the listbox display and then when the...
4
8910
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 Form_frmSingleRegistrant f.Caption = "New Registrant" f.cmdSave.Caption = "&Save New Registrant"
1
2992
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 aspects of the project. On the masterform I have two unbound listboxes that I populate with information regarding the current record in one of the subforms.
4
26202
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 make a change in the name field in the details, then refresh the list box with new name? Please help and thanks!
9
7026
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 it return the associated records to a listbox. Once the listbox has the records, I want to select a record, which will open a form associated with the selected record in the listbox.
6
9970
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 display the customers that I added. Unfortunately, the listbox display does not change. If I close the form and reload it, then the listbox will show the new customers. Any suggestions on how to fix this?
6
7989
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 firm name in a combo box above the list box. The listbox and the combo box join on firm name. The listbox records what address was selected in the address table by the way of an address id number. I set up a macro to requery the listbox when you...
1
2022
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 conditions for my listbox are: 1. The three columns (dubbed as Change History) are taken from IssueAudit under conditions that the ChangedFields value is 'CATE' - category. 2. The SAF-NO, a FK is the same key as the SAF_NO primary key in SAF
6
6086
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. Assume: 1) Using MS Access 2003 in an ADP project, SQL Server 2000 Enterprise backend 2) Main form is populated by a stored procedure, which works flawlessly 3) There is a listbox on the form that will display matching records based on a key...
0
9455
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9271
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10031
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9869
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9838
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8709
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5140
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5302
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3354
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.