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

On Oct 14, 11:17*pm, jonceramic <joncera... (AT) gmail (DOT) com> wrote:
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

jonceramic wrote:
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

On Oct 15, 12:33*am, jonceramic <joncera... (AT) gmail (DOT) com> wrote:
Turn off the Name Autocorrupt thing, from the menu bar->Tools->Options-
Q