473,325 Members | 2,785 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,325 software developers and data experts.

Subform help! Child/Master fields keep repopulating!

Hi,

I have a 2 subform form, which uses the selection of a row in subform
1 to show a set of rows in subform 2.

I have my queries pointing directly to fields on my form to choose
what data is shown.

However, when I first populated this form with my subforms, I was dumb
(apparently) and had it accidentally pick "List_ID" as my child/master
field for subform 2.

Now, when I wipe out List_ID as my child/master field. The form works
perfectly when it first opens.

But, the second I choose/change anything on my form. Presto/chango,
my nemesis - List_ID is back in the spot limiting my data in Subform
2. Blargh.

WTF! I'm on Access 2003. And I'm going to try to add the subform to
the form without setting any child/masterfields.

But, does anyone know what I'm doing wrong? I've cleared "List_ID" in
both the properties window and the little ... popup.

TIA,

Jon
Oct 15 '08 #1
3 2447
On Oct 14, 11:17*pm, jonceramic <joncera...@gmail.comwrote:
Hi,

I have a 2 subform form, which uses the selection of a row in subform
1 to show a set of rows in subform 2.

I have my queries pointing directly to fields on my form to choose
what data is shown.

However, when I first populated this form with my subforms, I was dumb
(apparently) and had it accidentally pick "List_ID" as my child/master
field for subform 2.

Now, when I wipe out List_ID as my child/master field. *The form works
perfectly when it first opens.

But, the second I choose/change anything on my form. *Presto/chango,
my nemesis - List_ID is back in the spot limiting my data in Subform
2. *Blargh.

WTF! *I'm on Access 2003. *And I'm going to try to add the subform to
the form without setting any child/masterfields.

But, does anyone know what I'm doing wrong? *I've cleared "List_ID" in
both the properties window and the little ... popup.

TIA,

Jon
Update:
Recreating the field didn't help.

Since I'm using the same form table as I'm using the in the query for
subform 2, I decided that it was probably some name autocorrect thing
going on. (I have a join so that everything from my "seed" contacts
table is show, and on my "chosen" contacts table, only those with
matching "List_ID"'s are joined.)

So, I changed the List_ID to be named "FakeList_ID" via a query
expression, and now everything shows up. As planned. Without it
reinserting List_ID/List_ID as my master/Child relationship. But, I
wish I didn't have to do this.

Still looking for a clue for a better fix.

Thanks,

Jon
Oct 15 '08 #2
jonceramic wrote:
Hi,

I have a 2 subform form, which uses the selection of a row in subform
1 to show a set of rows in subform 2.

I have my queries pointing directly to fields on my form to choose
what data is shown.

However, when I first populated this form with my subforms, I was dumb
(apparently) and had it accidentally pick "List_ID" as my child/master
field for subform 2.

Now, when I wipe out List_ID as my child/master field. The form works
perfectly when it first opens.

But, the second I choose/change anything on my form. Presto/chango,
my nemesis - List_ID is back in the spot limiting my data in Subform
2. Blargh.

WTF! I'm on Access 2003. And I'm going to try to add the subform to
the form without setting any child/masterfields.

But, does anyone know what I'm doing wrong? I've cleared "List_ID" in
both the properties window and the little ... popup.

TIA,

Jon
You probably needed to set the Listbox to the new value first. Ex:
Forms!MainForm!ListBox = Me.IDValue 'change to your names
Forms!MainForm!SF2.Form.Requery

You could set the filter manually as well
Forms!MainForm!SF2.Form.Filter = Me.IDValue
Forms!MainForm!SF2.Form.FilterOn = True
Oct 15 '08 #3
On Oct 15, 12:33*am, jonceramic <joncera...@gmail.comwrote:
On Oct 14, 11:17*pm, jonceramic <joncera...@gmail.comwrote:


Hi,
I have a 2 subform form, which uses the selection of a row in subform
1 to show a set of rows in subform 2.
I have my queries pointing directly to fields on my form to choose
what data is shown.
However, when I first populated this form with my subforms, I was dumb
(apparently) and had it accidentally pick "List_ID" as my child/master
field for subform 2.
Now, when I wipe out List_ID as my child/master field. *The form works
perfectly when it first opens.
But, the second I choose/change anything on my form. *Presto/chango,
my nemesis - List_ID is back in the spot limiting my data in Subform
2. *Blargh.
WTF! *I'm on Access 2003. *And I'm going to try to add the subform to
the form without setting any child/masterfields.
But, does anyone know what I'm doing wrong? *I've cleared "List_ID" in
both the properties window and the little ... popup.
TIA,
Jon

Update:
Recreating the field didn't help.

Since I'm using the same form table as I'm using the in the query for
subform 2, I decided that it was probably some name autocorrect thing
going on. *(I have a join so that everything from my "seed" contacts
table is show, and on my "chosen" contacts table, only those with
matching "List_ID"'s are joined.)

So, I changed the List_ID to be named "FakeList_ID" via a query
expression, and now everything shows up. *As planned. *Without it
reinserting List_ID/List_ID as my master/Child relationship. *But, I
wish I didn't have to do this.

Still looking for a clue for a better fix.

Thanks,

Jon- Hide quoted text -

- Show quoted text -
Turn off the Name Autocorrupt thing, from the menu bar->Tools->Options-
>Gweneral(Tab)->Name Autocorrect->Track Name Autocorrect Info.
Q
Oct 15 '08 #4

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

Similar topics

7
by: ChrisR | last post by:
Hi guys My app is a simple Main form with a few Subforms that are not linked, and a few pop forms. Problem is: I have a pop form with a Listbox with a list of records related to the...
25
by: Lyn | last post by:
Hi, I am working on a genealogy form. The only table (so far) lists everybody in the family, one record per person. Each record has an autonum ID. The parent form (frmMainForm) displays the...
1
by: John Michael | last post by:
I have a form that has a subform that has a subform. The subform loads a record based on a combo lookup box in the main form. I'm trying to set a value in the subform based on a value in a...
3
by: Paul T. Rong | last post by:
I have a listbox (of product names) control on my form. I want to pass the selected item (a product name) to a subform, and the product unitprice should apear automatically next to the product name...
2
by: Paul T. RONG | last post by:
Hello there, I have a main form frmOrder and inside a subform sbfrmOrderDetail. When I add records from main form to subform, it is alright when the records don't exceed 40 rows (the subform's...
5
by: ego | last post by:
Hi all , I had created the following Form/SubForm structure : MainForm SubForm A (SubForm of MainForm) SubForm B (SubForm of SubForm A) SubForm C (SubForm of SubForm B) SubForm D ...
9
by: PC Datasheet | last post by:
I'm stuck on something that seems should be easy and I need some help. My main form has an option group with five options. My subform chooses from different lists depending on which option is...
4
by: Macbane | last post by:
Hi, I have a 'main' form called frmIssues which has a subform control (named linkIssuesDrug) containing the subform sfrmLink_Issues_Drugs. A control button on the main form opens a pop-up form...
1
by: Stinky Pete | last post by:
Hi everyone, I have been updating a file that uses a main form that contains a subform (as a datasheet). The main form really does not do anything on opening except maximizes to the users...
5
by: samdev | last post by:
I have created two combo boxes in a subform.... For example 1. Combo Box State 2. Combo Box City 3. When a state from the Combo Box State is selected, the City combo box updates to reflect...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.