Filter based forms - Microsoft Access / VBA

4 New Member

Hi guys,

I am really newby in access. I want to make filter based form, means we select value from the dropdown list, and sub report gets updated with that selected value.

What i did:

Created main form
Created dropdowl list
Created button
Created subform

Now, how can I update subform's data with selected value from dropdownlist?

I tried to put and event on button, and put
eTemplate_subform1.SourceObject = "select * from LAudience"
eTemplate_subform1.Requery

but, seems like this code is not executing. How can i debug in access?

ur help will be appreciated.

Sep 9 '06 #1

Subscribe Reply

1654

ckv

New Member

Hi guys,

I am really newby in access. I want to make filter based form, means we select value from the dropdown list, and sub report gets updated with that selected value.

What i did:

Created main form
Created dropdowl list
Created button
Created subform

Now, how can I update subform's data with selected value from dropdownlist?

I tried to put and event on button, and put
eTemplate_subform1.SourceObject = "select * from LAudience"
eTemplate_subform1.Requery

but, seems like this code is not executing. How can i debug in access?

ur help will be appreciated.

using ms access 2007 beta 2

Sep 9 '06 #2

Similar topics

7830

Filter Form through sub-form values

by: Robert Neville | last post by:

I would like to add filter functionality to my database whether through the Main form or the subform. This question may be rudimentary, yet I have not less experience with filtering data outside...

Microsoft Access / VBA

1616

Using Filter by Form on Tab Controls

by: Tony Williams | last post by:

I have a main form based on Table1. The form has a tab control of three pages. Each page has a subform based on a different table ie subform1 based on Table2, subform2 based on Table3 and subform3...

Microsoft Access / VBA

2747

Filter by Form

by: Tony Williams | last post by:

Sorry to repost but I cannot work this out. Can anyone come up with a suggestion? I have a main form based on Table1. The form has a tab control of three pages. Each page has a subform based on a...

Microsoft Access / VBA

2072

access97 vs access2000 advance filter

by: swilson513 | last post by:

In Access97 I was able to have an advance filter on a form that had a Like statement so when you applied the filter EACH time it would asked for the criteria. In 2000 the same filter doesn't asked...

Microsoft Access / VBA

6067

SQL Server - Filter

by: Bob | last post by:

I am in the process of upgrading an Access database to SQL Server (and climbing that learning curve!). The wizard happily upgraded all the tables and I can link to them OK using ODBC. The...

Microsoft Access / VBA

4070

passing filter to a sub form

by: Anja | last post by:

Hi everyone, I have a sub form that references a query to get the results. However, what I want to do is filter the results further based on a certain criteria. How can I tell the sub form to...

Microsoft Access / VBA

1986

VBA and Filter Question

by: Soulspike | last post by:

Form name to filter = frmSortFor Filter based on list box from frmTest= lstSortFor Form containing list box = frmTest Field (CompCodes) data format = "PM SM TS EW WA" I have a database that I...

Visual Basic 4 / 5 / 6

4188

Remove filter does not work...

by: Matthew Wells | last post by:

Hi there. I am a programmer for a living, but this problem has my whole team stumped. I have a subform based on a query. I'm not using the "LinkMaster/ChildFields" properties ( I have my...

Microsoft Access / VBA

1395

creating and using a filter

by: JohnHo | last post by:

I am trying to use the filter method with a form Using the Access/VBA documentation I have created a filter which looks like this me.filter = "lngCaseID = 18905" me.filter on = true

Microsoft Access / VBA

6765

filter a subform based on multiple multi select list boxes

by: woodey2002 | last post by:

Hi Everyone and many thanks for your time.. I am trying to begin access and a bit of VBA i am enjoying it but I have a annoying problem I just can’t get any where on. My databse mostly includes...

Microsoft Access / VBA

7205

What is ONU?

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,...

General

7093

Changing the language in Windows 10

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...

Windows Server

7287

Problem With Comparison Operator <=> in G++

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,...

C / C++

7349

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

7008

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

5594

AI Job Threat for Devs

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,...

Career Advice

4688

Couldn’t get equations in html when convert word .docx file to html file in C#.

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...

C# / C Sharp

3168

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1521

transfer the data from one system to another through ip address

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 ...

C# / C Sharp