Form & Subform Searching

z.ghulam

Hi,

I have 2 subforms embedded within a main form. Whenever I do a Filter,
the data in the main form appears, but nothing shows in either
subform?

Is there a way round this?
I was using the Filter-by-Form button on the toolbar.
I've also got a Find Record button on the form...
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 0, 2, acMenuVer70

and the the filter button .....
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 2, , acMenuVer70

Any help would be greatly appreciated
Cheers
Zieshan

Jun 27 '08 #1

Subscribe Post Reply

1655

z.ghulam

On May 28, 12:53*am, z.ghu...@gmail.com wrote:

Hi,

I have 2 subforms embedded within a main form. Whenever I do a Filter,
the data in the main form appears, but nothing shows in either
subform?

Is there a way round this?
I was using the Filter-by-Form button on the toolbar.
I've also got a Find Record button on the form...
* * DoCmd.DoMenuItem acFormBar, acRecordsMenu, 0, 2, acMenuVer70

and the the filter button .....
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 2, , acMenuVer70

Any help would be greatly appreciated
Cheers
Zieshan

Problem solved!!

Jun 27 '08 #2

by: Jason | last post by:

I would like to be able to place a command button on a primary (parent) form that opens up a subform. I want to use this subform to search for or limit the recordset of data in the primary form. ...

Microsoft Access / VBA

Main Form & Continuous Subform (with Requery) Problem

by: Dave Boyd | last post by:

Hi, I have two very similar forms each with a subform. The main form gets a few fields from the user and passes this back to a query that the subform is bound to. The requery is done when the...

Microsoft Access / VBA

Form/Subform Searching

by: Simone | last post by:

Hi All, I have a Find Record button setup in most of my forms in order to find a specific customer's details. I have just noticed today though that this search will only find the customer if it...

Microsoft Access / VBA

focus from main form to sub form

by: Stu | last post by:

Hi, I have a combobox who's values change the recordsource of the form. Within this form, there is a subform, whos records also need to change pending the value in the combobox. I am able to get...

Microsoft Access / VBA

filter by form/subform

by: dhowell | last post by:

In reading some of the posts on this group, it appears as though it is not strait forward at all to filter a form, which has subforms, by criteria which are either on subforms or span more than one...

Microsoft Access / VBA

access form search record before delete

by: Steven | last post by:

Hi, Would need some thought about using a button of the existing form to search record before deleting it. Any quick help is very appreciated. Steve

Microsoft Access / VBA

Form & Subform Requery Problem - ADO Related?

by: mrowe | last post by:

I am using Access 2003. (I am also using ADO in the vast majority of my code. I recently read a post that indicated that ADO is not all that is was initially cracked up to be. In the back of my...

Microsoft Access / VBA

Getting Current Form & Subform Info To Either Print Or Dump Into a Record

by: Christina123 | last post by:

Currently working with Microsoft Office 2000 and whatever version of Access came with that. I am developing a database to track the comings and goings of shared tools. Everything works...

Microsoft Access / VBA

Linking form & subform information

by: PotatoChip | last post by:

Ok, I have a form and a subform. The form shows a document with it's pertinent information. The subform has some of the same fields as the form and shows where the document was sent. The main form...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

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

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

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

Computer Hardware

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

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

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

Similar topics