Yet more confusion...

[sbaird]

Hello again..

I have a form (contacts), with a subform (calls). Tables are in a one
to many relationship, and work fine in queries, etc.. I can't get my
form to work the way I want though

Main form (Contacts) has last name, first name, phone, etc... Subform
(Calls) has date/time of call as well as results. On the main form I
have an unbound combo box that I have populated with the contacts last
names (it reads them from the contacts tbl). I want to be able to use
that combobox to select a contacts last name and have the form/subform
refresh/update to the record for the name within the combobox. If I
select a different name, the form should go to that name, etc...

I've tried several things, and here are my results. Anybody know what
I am doing wrong (besides everything!)?

- Right now, I select a name in the combo and have to tab out to
refresh the forms. Would like to get away from the tab requirement at
this point.
- However, my test d/b has four names in it, but the refresh only
seems to bounce back and forth between two names, regardless of which
name I select.

Refresh, requery, repaint.... nothing seems to be working correctly,
and I'm sure that I'm doing something stupid to make this happen like
this. I've tried a requery macro "onchange" and that didn't work.
Neither did putting it in code, using OnUpdate, etc... I've started at
the screen for at least 3 hours today. I've made other d/b's do this
and comparing the two, I simply can't see any difference.. Help!

[sbaird]

Would it be better to just have some sort of "find record" or "go to
record" function that searches for the record with the name in the
unbound combo box?

If so, could I get this to automatically run "onChange" or
"AfterUpdate"?

What would be the code for this? This seems like an easier way to make
it happen, but not sure...

[Tim Marshall]

sb****@cbpacific.com wrote:

Hello again..

I have a form (contacts), with a subform (calls). Tables are in a one
to many relationship, and work fine in queries, etc.. I can't get my
form to work the way I want though

Main form (Contacts) has last name, first name, phone, etc... Subform
(Calls) has date/time of call as well as results. On the main form I
have an unbound combo box that I have populated with the contacts last
names (it reads them from the contacts tbl). I want to be able to use
that combobox to select a contacts last name and have the form/subform
refresh/update to the record for the name within the combobox. If I
select a different name, the form should go to that name, etc...

I've tried several things, and here are my results. Anybody know what
I am doing wrong (besides everything!)?

- Right now, I select a name in the combo and have to tab out to
refresh the forms. Would like to get away from the tab requirement at
this point.
- However, my test d/b has four names in it, but the refresh only
seems to bounce back and forth between two names, regardless of which
name I select.

Refresh, requery, repaint.... nothing seems to be working correctly,
and I'm sure that I'm doing something stupid to make this happen like
this. I've tried a requery macro "onchange" and that didn't work.
Neither did putting it in code, using OnUpdate, etc... I've started at
the screen for at least 3 hours today. I've made other d/b's do this
and comparing the two, I simply can't see any difference.. Help!

Given that the main form is frmMain and the subform name is
frmMainSubCalls with the subform *control* on frmMain called subCalls.
The combo is called cboContact. Presumeably you have the recordsource
of frmMainSubCalls (ie, the subform control subCalls) set up so as to be
dependent on the value of the combo box.

Sub subCalls_AfterUpdate()

me.subCalls.Form.Requery

End Sub

Note - on a design note, you may well have this done, but you should
consider using an autonumber for each caller and use that as the foreign
key.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[sbaird]

Thanks, I'll give it a try. Question - it appears that this function
requerys the subform, but not the mainform. I'm not having problems
with the subform/child, only with the main/parent. Table relationship
(1 to many) works well and if I manually go to a record in the
main/parent, the subform follows along greatly because they are indeed
to together with a foreign key as you mention.

However, if I use the unbound combo box to state which contact I
would like to go it, none of it works. I need the mainform record to
update to whichever name I have selected in the combo box.

There is a BOUND combo box on the main form called "Full"
There is an UNBOUND combo box on the subform called "cboContact"

When I select "john jones" in cboContact, I want the mainform to search
the d/b, find the correct contact, and refresh the main/sub form to
display that info. When I select another name, I need it to do it all
over again for the new name. Would it be better to just try and figure
out a "go to record" routine of some sort instead of trying to
refresh/requery the screen? I know squat about VBA, so any help with
this code would be greatly appreciated.