REFRESH CURRENT RECORD

[clawdogs]

Hi. I have a form that uncludes data from two tables RequesTracker
and NAM. The NAM table is linked (spreadsheet) the NAM table in an
access table.
The current relationship is Include ALL records from 'RequestTracker'
and only those records from 'nam' where the joined fields are equal.
Basically the NAM data is raw order data that I'd like to include when
updating the linked RequestTracker data. Yes, there is a unique ID
that links in a query for the form.

So here's my problem. When I populate the ID field that's linked to
the NAM records, the form doesn't show the associated NAM data unless
I close the form, re-open it and do a "find". I've tied doing the
refresh thing, the requery thing etc on the ID, Lost Focusevent. To
no avail. How can I refresh the data from NAM on the current record
as soon as I populate the ID field? Any suggestions?

 

[Wolfgang Kais]

Hello "(e-mail address removed)".

Hi. I have a form that uncludes data from two tables RequesTracker
and NAM. The NAM table is linked (spreadsheet) the NAM table in an
access table.
The current relationship is Include ALL records from 'RequestTracker'
and only those records from 'nam' where the joined fields are equal.
Basically the NAM data is raw order data that I'd like to include when
updating the linked RequestTracker data. Yes, there is a unique ID
that links in a query for the form.

So here's my problem. When I populate the ID field that's linked to
the NAM records, the form doesn't show the associated NAM data unless
I close the form, re-open it and do a "find". I've tied doing the
refresh thing, the requery thing etc on the ID, Lost Focusevent. To
no avail. How can I refresh the data from NAM on the current record
as soon as I populate the ID field? Any suggestions?

How could you join an Access table to a linked Excel table and make the
data be updatable? I can't even figure out hou you did that.
(I'm using Access and Excel 2003)