Help! Unbound controls cause listbox to requery??

Have not seen this before, in 10 years of Access use.  Running A2003 on XP 
Pro system.

I've got a subform on one of my forms that contains a listbox and several 
other controls.  The other controls (a combo and a text box) are unbound, and 
are filled in based on the selection in the listbox and a value on the main 

I just modified the subform, so that I now have an option group which allows 
the user to view the listbox filtered or unfiltered.  The user selects an 
option from the group and the listboxs RowSource is changed to the 
appropriate query.  What is supposed to happen is that when an item in the 
listbox is selected, the combo box and textbox values are set using a 
DLOOKUP( ) of different tables.  This works OK.

Now for the strange part.  When I select the filtered view of the listbox, 
and move the cursor to either the combo box or the text box, nothing special 
happens.  However, when I change the RowSource of the listbox to the 
unfiltered query, and move my cursor to either the combo or the textbox, the 
listbox requeries.  There is no code in the "SetFocus" event of either of 
these controls, and this requery is occuring before the combo even drops 
down.  I also checked, and there is no code in the listboxes LostFocus event 

Any ideas?

Email address is not valid.
Please reply to newsgroup only.
5/29/2007 7:13:01 PM
access.formscoding 7493 articles. 0 followers. Follow

0 Replies

Similar Articles

[PageSpeed] 20


Similar Artilces:

Where can I get a free Inventory control spreadsheet
I am looking for a Inventory/Stock control excel template, but I don' want to pay for it!!!!!! Can anyone suggest a sit -- Message posted from You can search in Google, using keywords like Excel and Inventory. Or look at the templates on the Microsoft web site: Pritch14 < wrote: > I am looking for a Inventory/Stock control excel template, but I don't > want to pay for it!!!!!! > > Can anyone suggest a site -- Debra Dalgleish Excel FAQ, Tips & Book List

Help Sendobjest
I am hopping some one can help me I have an application in Access 2000 which has been running on XP and XP professional for a very long time every morning this application creates a list of reminders it then creates an E-Mail for each reminder and with a loop it sends all the e-mails one at a time the code is DoCmd.SendObject acSendNoObject, , acFormatTXT, StrFullAddress, , , strMailSubject, strMailMsg, False All of a sudden a couple of months ago I noticed that it was sending the first mail ok with the usual out look message and then it just looped through the rest but did not send...

meeting invites now show up as emails only
As of very recently, Outlook invites sent from my work calendar to my home calendar (both Outlook, although work Outlook is 2003 I think) now only show up as emails, not as calendar invites. Does anyone have an idea why this is happening - it used to work just fine. Fixes? ...

Please Help: Toolbars in DLL Dialog
Hello, Creating toolbars in an EXE app is a relative piece of cake. However, I am trying to insert a toolbar into a DLL dialog. This is how my DLL dialog works: 1) Contents of a function exporting a dialog AFX_MANAGE_STATE(AfxGetStaticModuleState()); CSvg* dlg; try { dlg = new CSvg(); dlg->Create(IDD_MAIN_FRAME); dlg->ShowWindow(SW_SHOW); } catch (CSvg *dlg) { dlg->PostNcDestroy(); delete dlg; } 2) Use a function in my Dialog class to insert a toolbar: int CSvg::OnCreate(LPCREATESTRUCT lpCreateStruct) { if (CDialog::OnCreate(lpCreateStruct) == -1) return -...

Where free 2 sigma statistical process control chart, free?
where can I download a free statistical process control chart template? ...

NEED HELP-wrong formatting saved ??
After using word 2007 and saving a word file, it changed the formatting from the previous file (i think it was .wps microsoft works word processor) and now its all messed up.....I think I saved it in some other wrong encoding, whenever I open this file now half of it is in some weird looking unreadable this with wha捬屨捦ㅳ尠晡‰汜牴档晜獣‰歜牥楮杮尰扤档慜㍦㔱㔰楜獮獲摩㌱ㄳ〶‷਍灜牡素筽⩜灜獮捥癬ㅬ灜畮牣屭湰瑳牡ㅴ灜楮摮湥㝴〲灜桮湡⁧屻湰硴慴ges! That is what seems to happen once the system breaks its laws from the inside. ......couldnt find online solutions...does anyone have any suggestions or s...

Controlling Gap Width for BAR Chart
Hi, I have the following data for example. A = 2 B= 3 C = 4 I can create a 2 D Bar chart from this quite easily. Now If I make the data to A = 2 , 3 B= 3 , 4 C = 4 , 5 I do want to plot the data on the basis of first two values as mentioned in the first example, but I want to control the width of the Bar from the value given after comma. Please help. On Sat, 24 Feb 2007, in microsoft.public.excel.charting, Fazi <> said: >I have the following data for example. >A = 2 , 3 >B= 3 , 4 >C = 4 , 5 > >I want to plot the data on the basis of firs...

Help with creating a formula
Hello! I am trying to create a formula that will sum up certain criteria from one column as it relates to criteria in the same row in another column. For example, I want to sum up all the entries that begin with the letter "H" in column A as it relates to an entry of "2" from column B that is in the same row as the "H" entry from column A. COLUMN A COLUMN B H10 2 G01 2 H09 3 H15 2 H12 2 If there is such a formula...

NDR Help
Hi, I hope someone can help on this. A few people have complained they cannot e-mail to us always. They get an NDR. This is very intermittent it seems and not everyone is affected. They have forwarded the NDR they have received. I've attached it below. I can't work out if our mail server has sent that to them or if it is generated by their company e-mail server. This happens mainly with one company but i think it has happened to some others as well - i can't be sure but the one company mainly (or even only). It is odd in that they can e-mail and get through then do it aga...

Tab Control #7
Hi, I'm using a basic tab control, how to place a bitmap image onto it ? Can a bitmap image be inserted only on the tab strips. (what i mean by tab strips is the part of tab, which holds name for that tab). Also, how to get the 3D effect for the tab ? (Like XP tabs) Hi You can bitblt for each tab clicks. I mean when you change the tab just repaint the dialog with new bitmap. Best regards, Amal Quote raj: Can a bitmap image be inserted only on the tab strips. (what i mean by tab strips is the part of tab, which holds name for that tab). ------------------------------------- Y...

Drag and drop help
I am trying to get drag and drop working between a few windows in my application. I can get the dragging started, but can't get away from the 'no-entry' mouse cursor. I have read through the MSDN and I have done the following in a CTreeView derived class called TreeCtrlArtifacts: void TreeCtrlArtifacts::OnTvnBegindrag(NMHDR *pNMHDR, LRESULT *pResult) { LPNMTREEVIEW pNMTreeView = reinterpret_cast<LPNMTREEVIEW>(pNMHDR); // TODO: Add your control notification handler code here CUIntArray arrayOfSelected; arrayOfSelected.Add(0); CMainFrame *main = (CMainFrame*) AfxGetMa...

Button form control does not work
I have spent over 5 hours trying to get the button wizard to do a simple thing. Open a form and show data in that form that matches the name in the form where the button is but when i follow the wizard the button allways go to the first entary in the second form eg i have the form (form1) open on emma (record 3) and want to open a second form that also contains emma the wizard puts the following in to a macro form2, Form, , "[Full Name]=" & [Full Name], , Normal but when i test the button it open the second form with the first record which is not emma why d...

Windows Mail spelling control Dutch
Spelling control of my Windows Mail (Version 6.0.6000.16386 / Vista_rtm.061101-2205) is presently limited to English, French, German, Spanish. I want to include spelling control for Dutch. I received below advise, but after donwload and installation of the most recent version of Wlndows Live, no upgrade to below mentioned latest version has happened, nor is there a complement of 37 spell check languages. ********************** Make sure you have the latest version (14.0.8089.0726), and you have to be online to see the full complement of 37 spell check languages. ****************...

Recordset Help Needed
I have the below code that works some of the times, but not all. Here is my issue. If there is no records in the table it works the first time. Then when I go to add another record it says "No Current Record". If I close the form and then re-open it, it work. I thought by adding the Set rs = Nothing it may help. It did seem to do anything. Private Sub TRAN_TYPE_DblClick(Cancel As Integer) Dim rs As DAO.Recordset Dim rs1 As DAO.Recordset 'Save any edits If Me.Dirty Then Me.Dirty = False End If 'Check there is an order in the form. If...

*CANT log into Windows -please help
Hi, I need step by step instructions on how to use my recovery console CD in order to fix a problem. Here is my prob: A virus/malware scan I did probably messed up my logon file. The antivrus program either removed or quaranteined the virus/trojan that was attached to my logon file. Because when AVG prompted me to reboot after this scan, It stopped at the welcome screen logon part. I click on my user name (only one there) and it says its logging on...But then it says saving settings and nothing else happens. My machine does not reboot or anything. It just stays at this logon sc...

HELP! CFtpConnection GetFile cause memory leaking, WHY?
I'm trying to use CFtpConnection GetFile to download files from a WS_FTP server. I found if I download 1000 files (Size from 17KB to 25KB ), it can cause about 10M memory leaking. When I commented out the GetFile( ) line, there was no memorry leaking. WHY? Following is part of my source code: try { // Request a connection to Image Server //Use default FTP Port //Use Passive MODE pConnect =3D sess.GetFtpConnection(strISIP,strFtpUser,...

need basic help setting up a graph
Hello, I am trying to set up a chart of days and times. The X- axis shoul have the days of the week (mon, tues, etc) and the Y - axis should hav various times of the day. I would like to have a line from on specific time on one day to another specific time on the next. So, point would be monday at 10:00 and the next would be tuesday at 1:00 followed by wednesday at 12:00, etc. Any suggestions?? Thanks fo your help Davi -- Message posted from Hi David, See my attachment. Is that the situation you explained? I use formula =IF(B2<0.5,B2+1,B2) in column ...

How to control what tabs are displayed in Active Directory Users and Computers
I do not see the value to allow the delegate to change the City, State, Country, Office. What am I doing wrong. (see info below) Also is there a way to limit the view of what is shown in Active Directory users and computers, so the Delegate only sees the General, Address, Telephone and Organization tabs? I know the step below lock them out of the other tabs, but there would be less confusion..even if it is registry hack on that local pc. Here are the steps I have done so far: Step 1. Create a Security Group Called 'XYZ' (call it what ever you want Step 2. Open Active Directory User...

Crystal Reports help
We are currently using GP 8.0 and Crystal Reports 10. We will be running most of our reports through Crystal because you can do so much more than with the Report Writer. I am looking for a good reference book for Crystal 10 (this is the first version I have ever used) any suggestions? You can get books on Crystal 10 in any large bookseller. One thing you won't get is how to use Crystal with Great Plains. There was some training materials available. You will want to consult the Great Plains SDK for help on the tables to use. JO wrote: > We are currently using GP 8.0 and Crystal R...

Help with an IIF expression
My database is similar to a checkbook register and contains the following fields: Amount Combo box with the expense categories of Housing, Medical, Personal I have a report that gives me a monthly total for each of these categories and a grand total of all categories for the month. However, I need help in calculating a monthly total for Medical and Personal combined. Please help me with the expression. I want to add a text box to my report to show the results of this expression. Thank you! You can create a hard-coded expression like: =Sum(Abs([ExpCat] IN ("Medi...

Move data from column to rows HELP!!!
Hi thanks for taking the time to look at my problem, currently i have column that has thousands of rows of information in it, it looks lik this A 40432 432654 3432 532543 32432 523 53425 532532 532 523 532 111 222 333 666 numbers that go on into mabye the 5000-6000 range what i need to do is have that data moved So it looks like this A | B | C 40432 | 32432 | 532 432654 | 523 | 523 3432 | 52432 | 111 532543 | 532532 | 222 So on and so on, so instead of 1 column with 6000 lines it ...

Can anyone help with this chart?
I would like to have the following values/labels on the y and x axis of any style of chart: X-axis: July, August, September etc for a full financial year; Y-axis: FB, AP, DR, LA, PC. OR the other way around. Presently the Y-axis simply displays the labels 'Jan Jan Jan Jan Jan' etc. Thank you. Any help would be much appreciated. Check out Jon Peltier's article on creating a vertical category axis: -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "A little stuck" wro...

Newbie Needs Help With Formatting E-Mails
Newbie Needs Help With Formatting E-Mails Hi all. I'm new to this site and would appreciate some formatting help. I created a new Word doc and copied and pasted some graphics and some simple text boxes in to it. The graphics and text boxes were created in Powerpoint by someone else. Looks fine on my screen. Before sending it out via e-mail to an Outlook e-mail group I have, I first sent myself a test message to see what it would look like on the receiving end. It looks a mess! The text boxes are all over the place, as is the text that is not in a box. Also, everything slide over to ...

Worksheet Help req PLZ
Hey All, I have a small issue where I have created a worksheet called data and in Cell A3 I have a linked cell to another worksheet and cell "WK48!A2" In Cell A4 in the "data" worksheet I need a link to "WK49!A2". I would like to link all cells in Column A to consecutively "WKxx" worksheet once I add them to the workbook. I thought I could drag them mouse down but al I get is links to consecutive cells in "WK48" work sheet. Please help mag()() Try =INDIRECT("'WK"&ROW(48:48)&"'!A2") -- Reg...

Help, how do I get an exe file with outlook 2002.
is there a way to turn off the GD stupid F#@$ing level one interecept "feature" in outlook? I am so angry with this stupid program@! I need to download an exe file and cannot with this software! Maybe if you washed your mouth out with soap, someone would be willing to help you. This is a technical forum -- not a place for ranting fools. "Sean" <> wrote in message news:5a8001c42d8f$52c08b20$a401280a@phx.gbl... > is there a way to turn off the GD stupid F#@$ing level > one interecept "feature" in outlook? > > I am so angr...