To anyone and all gurus:
Any help would be GREATLY appreciated! Thanks in advance

Application background:
Multi-user environment, split access database, access ver 9.0x
Developing the Access frontend on Win 2000, clients are running
Win 98.

Problem:
I have a form that has a Subform/Subreport that has it's
RecordSource bound to a query. When a new record is saved the SubForm
is supposed to reflect the new record added and display it, but it
doesn't. The second problem is when I can get the new record to show
up in the list, when I select it it doesn't become the 'live' record
for editing on the main form. I have tried refreshing, requerying etc
and still have no luck. Has anyone had a similar issue when selecting
a newly created record or could someone with more experience give me
some advice on tackling this one?

Wes

You can force a subform control to be refreshed by reminding it of its
sourceobject name thus:-

Me!SubformControl.SourceObject="<Subform Name>"

or, if you don't know the name of the subform

Me!SubformControl.SourceObject=Me!SubformControl.S ourceObject


Tony R.

"TC" <a@b.c.d> wrote

I have a main form which has a tab control in which contain the
other Subforms/Subreports controls exist.

Yes, the 'list' is the returned records from a Query that the
Subform is bound. I have started looking into using a ComboBox instead
of the Subform control but I have discovered that using a ComboBox
only allows one field in a db table to be displayed or monitored (or
am I wrong?). If I go with using the ComboBox, is there a way to
display the results of a Query that retrieves a 5 field set of records
off an access db table? Thanks for your reply!!

Thanks for the help you guys!

After taking Tony R's advice I have gotten the Subform to refresh
after a New record is added. By the way, the New Record is added on
another Form which is viewed after clicking a Tab on the Tab Control
(positioned on this Main Form).
After this Subform refreshes now it displays the 'Newly Added' record
in the Subform 'list' but when I select it, it doesn't display it as
being the current 'live' record on the Main Form for editing. I can't
figure out why.

This problem has started as a result of another user within the
company creating a New Record and after saving the record, it is added
to a 'queue' (the Subform list) for another user to select and do his
work with, but when that user selects the record on the Subform, it
doesn't actually 'select', all other older records can be selected in
the Subform though. Problem seems to only be with Newly created
records. The only work around we have found is to close the frontend
and reload, then all Subform Records (including the New ones) can be
selected. Has anyone seen this issue before?

A Continuing Thanks in Advance!