473,587 Members | 2,580 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Refresh data in a continous form

77 New Member
Hi,

I have a continous form that displays Name and Address of Suppliers.
In the form there is a combo box for 'Active Address' and 10 other text boxes. All the fields coem from one table, "Primary Suppliers".
The combobox is for 'Active Address' with values 'Yes' and 'No'.Control source of the form is,
Select * from PrimarySupplier s where [ActiveSupplier]="Yes". I want the form to display only the Suppliers who has 'Active address' = "Yes".If user selects "No" in the combobox for a supplier I want the form to refresh and not show that particular supplier record in the continous form.

Please treat this as urgent and help me solve this.

Thanks
Sep 11 '08 #1
5 2121
missinglinq
3,532 Recognized Expert Specialist
You need Me.Requery not Refresh. Place it in the AfterUpdate event of the combobox. But why in the world would you use a combobox for a simple Yes/No answer, instead of a checkbox?

Linq ;0)>
Sep 11 '08 #2
NeoPa
32,566 Recognized Expert Moderator MVP
Are [Active Address] and [ActiveSupplier] two separate fields in the table. If so then a better explanation is called for. If not, then such carelessnes will waste time.

Either way, you don't ask the question in a way likely to allow speedy resolution.

PS. With full and clear information this is quickly and easily answered I'm sure.
Sep 11 '08 #3
missinglinq
3,532 Recognized Expert Specialist
Good catch, Ade! I missed what I assume is a typo, but, of course, doesn't have to be!

Linq ;0)>
Sep 12 '08 #4
AccessHunter
77 New Member
Hi,

Thanks for the replies. Sorry if I confused you, ActiveAddress and ActiveSupplier is the same field.

Thanks
Sep 12 '08 #5
NeoPa
32,566 Recognized Expert Moderator MVP
You have a single field with two names! Are you sure?

Perhaps you could provide some meta-data info to help clarify this situation as I'm surely confused.

This will work much better if you can post the meta-data (info about the layout / structure) of the table in the same way as I use in my example. Click on the Reply button and you will have access to all the codes I've used. PK & FK stand for Primary Key & Foreign Key respectively. Please don't use any TABs in your formatted layout as this will not display correctly - Spaces only for layout.
Table Name=[tblStudent]
Expand|Select|Wrap|Line Numbers
  1. Field           Type        IndexInfo
  2. StudentID       AutoNumber  PK
  3. Family          String      FK
  4. SName           String
  5. University      String      FK
  6. Mark            Numeric
  7. LastAttendance  Date/Time
Sep 12 '08 #6

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

Similar topics

0
1719
by: gavo | last post by:
Hi. using A2K; i have a form containing a continous subform. The question is, how can i call a calculation for one of the fields in the continous subform from the main form. At the moment i have a button on the main form that will call a public code containing the calculation i need, the problem i have is that it will only perform the...
10
9233
by: tasmisr | last post by:
This is an old problem,, but I never had it so bad like this before,, the events are refiring when clicking the Browser refresh button. In the Submit button in my webform, I capture the server side click event and I update session information to track the visibilty of some panels in a wizard type navigation ("Next >>" and "<< Back" buttons).....
2
8164
by: Robert | last post by:
I am trying to give the user dynamic search capabilities to select almost any record in the database from criteria they select. Everything seems to work except when I open the display form to display the data to the user. If that form is already open, how do I make it refresh its data source and display the new data. Here is what I am...
12
6027
by: martin1 | last post by:
All, is there window form refresh property? I try to set up window form refresh per minute. Thanks
3
4399
by: colleen1980 | last post by:
Hi: Can any one please help me when user select 2 dates from DDLDate1 10/09/2006 and DDLDate2 10/12/06 and the name and it close the form. I need to create multiple records in the another table on the basis of two dates like that. Data in continous form table1 ----------------------------- Data entered in continous form 10/09/2006...
3
7516
by: David Cartwright | last post by:
Hi all, I'm having a weird time with a call to the Refresh() method of a DataGridView. I have a VB.NET 2005 Windows application with a main form and a "worker" thread. The main form delegates a Sub to the worker so that the latter can refresh the DataGrid after updating the DataTable driving it. When I run the app under the debugger,...
1
2027
by: Karl | last post by:
I have a continous form based on 1 table. On the form I have a button that sets the OrderBy to as follows DataSource = Me.RecordSource If Me.OrderBy = DataSource & ".PaymentDate DESC" Then Me.OrderBy = DataSource & ".PaymentDate" Exit Sub End If
6
5412
by: =?Utf-8?B?TWFyaw==?= | last post by:
Hi - I'm having trouble refreshing a datagrid control bound to a dataset that was created from the New Data Source wizard. What is the code required to refresh the datagrid with data from the data source (sql db)? More Details: The application is C# Windows (VS 2005).
0
1285
by: Karl | last post by:
On on continous form, when I place the cursor anywhere in a field, it highlights all the data to the right of the cursor instead of just placing cursor in the data. I have this form in several mdbs and they don't have this highlighting behaviour. The only difference I see is that in the lower right corner of the form is shows EXT in the...
0
7843
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...
0
8206
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. ...
1
7967
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...
0
8220
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5713
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5392
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3840
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...
0
3875
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2353
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.