472,793 Members | 2,068 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,793 software developers and data experts.

Requerying subforms in tab controls

I currently have a query that is joining two distinct pools of
information and turning them into one records with a unique identifier
This query is dependent on criteria passed from a form in a number of
text and combo boxes. This part of the form works fine.

On Open a Tab control is displayed but the subforms in each of the
three tabs are hidden until the required info is gathered from the
user. The subforms are then displayed, emphasis given to the first
tab which can display a number of records. What I want this tab
control to do is display the other tabs, the information pertaining
only to the record selected in the first i.e. setting some kind of
filter to say that [ID2]= Forms!MainForm!Subform.Form!Control.

I have tried this in two ways, neither of which have been completely
successful. The first tab is based on the same query as the main form
and returns all the records that match. The second tab is based on
the same query with a filter something like that above - no joy.

Secondly I replicated the query and merely added and additional query
like the filter above. This does produce the required result for the
subform cannot be requeried so as users flick through the available
records on the first tab, the second tab remains on the initial record
unless Shift+F9 is used.

I have tried The Requery Statement Forms!Mainform!Subform.Form.Requery
is the OnCurrent event of the first tab, the AfterUpdate event of a
control on this tab, the onCick event of the second tab top and
finally I tried passing the ID to a text box in the main form and then
requerying on the AfterUpdate event of this control - nothing
requeries the form other that Shift+F9. So I tried the Send Keys
commands on all of the above Events and again nothing.

I an absolutely 100% stumped and about 5 minutes away from scrapping
and starting again. Hopefully someone has some dawning inspiration.

P.S I have tried experimenting with the syntax of both the Requery
statement and filter but according to both here and the help, as is
should be fine.

Thanks in advance for any help

Nov 12 '05 #1
0 1904

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Mark Kola | last post by:
I have ran into an interesting situation. I have a calculated field based on a combobox column that somtimes is not requerying when I change the combo box value. Combobox cboCustomer 2...
by: Jenni | last post by:
I currently have a query that is joining two distinct pools of information and turning them into one records with a unique identifier This query is dependent on criteria passed from a form in a...
by: Steve | last post by:
I have a form, primary subform and secondary subform. A tab control takes up all the area of the primary subform. There are about 15 tabs on the tabcontrol. Each tab contains fields from the same...
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...
by: Dimitri Furman | last post by:
Given: Access 2002/2003 A subform in datasheet or continuous view, placed on a tab page (this last may or may not matter) Conditional formatting applied to some controls on the subform - format...
by: lauren quantrell | last post by:
A while back I got a requirement for the client to be able to adjust the relative heights of two subforms by click-dragging the mouse and I came up with a kludge solution using a border control...
by: Paddy | last post by:
Dear forum, In my database, I have one instance where a specific collection of 7 forms are expected all at one time, so I tried to build an entry screen where the entry form for each individual...
by: robert.waters | last post by:
Hello, If I have a form containing a Tab Control with N pages, each page containing a subform, are those subforms loaded into memory when another page has the focus? I have tried iterating...
by: Ecohouse | last post by:
I have a main form with two subforms. The first subform relates to the main form using an identity key (this works). The second subform relates to both the main and first subform. But I want to...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: lllomh | last post by:
How does React native implement an English player?
by: Mushico | last post by:
How to calculate date of retirement from date of birth

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.