473,396 Members | 1,784 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,396 software developers and data experts.

Requery Hidden List Box?

283 100+
Hello all,

I have an (unbound) form that i created so you can edit a record on the back end. I have 3 text boxes set up as the Criteria and then a bunch of other text boxes that fill in with the records information. Now what I also have is a list box. The box is used to show one of the criteria boxes (a box number) but the reason for it is in case of duplicate box number records. Now the problem im having is I always have to click on the box number in the list box to make it requery the information and fill in all of the boxes but i want to hide this box so it only is shown when I have a duplicate record.

Only problem im having is getting the information to refresh or requery (how ever you want to say it) with out the list box being visible. Any ideas how i could do this?

Everything else I have described works fine, its just this one problem.

Appreciate the help :D
Oct 16 '10 #1
1 1734
ADezii
8,834 Expert 8TB
You question is a little confusing, but you can Requery the List Box at any time, Visible or Not, simply by:
Expand|Select|Wrap|Line Numbers
  1. Me![<List Box Name>].Requery
Oct 16 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

15
by: C White | last post by:
I've got another drop list problem I am using the following code where users select a name, but it should pass a name and email into the table <select name="user"> <option value="<%...
1
by: Ed | last post by:
Hello! I have a report that includes a subreport. They are linked together by a common ID field. The subreport contains 6 controls, 5 of them text boxes with a control source and one of them is...
1
by: Chicken Kebab Abdullah | last post by:
I am making a database of my movie collection and I have a form which Shows a DVD Code in a combo, and a list of the divx movies on the dvd on the right in a list box. The combo boxes bound...
1
by: MDM | last post by:
I have a list box control that is bound to a query. The form is not bound to any source since I have a few list boxes from different sources. When the form opens the list box is populated...
2
by: Patrick Fisher | last post by:
I am using the following module code to display in a List Box all attached tables that start with tblProducts i.e. tblProductsSpain or tblProductsFrance etc I have other code which enables the...
3
by: damezumari | last post by:
I am using WinXP and MS Access 2003. I have a list whose row source is an sql. I insert a new record to the table the sql takes its data from. I requery the list and the new record appears. ...
2
by: bsder | last post by:
Hi, I m a newbie in html/javascript. I want to create two hidden listbox in a webpage. Can any please tell me how to do so in html / javascript? Thanks Sam
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...
9
by: hooijdonk | last post by:
Hi, using a form I have been trying to get a list box to display the values of database table and have two options on there. a) the user can select a list item and click a button to delete that...
8
by: bluemoon9 | last post by:
Does anyone know how to write a code to promt the selection at the last record in the list box?. I have this code below in the "On Click" event, when user click on the code, it close a form, requery...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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,...
0
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...
0
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,...
0
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...
0
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...

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.