self updating form field (w/ typo corrections)

[mark kubicki]

I am working on a project with a linked table and need to create an
automatically updating field on a form of the active project with
information from the linked table
---this ought to be easy (I'm certain); but with my limited, self-taught,
lack of knowledge...

the active project is: [FixtureSchedule]
with table: [tblFixtureTypes]
having fields: [manufacturer], [catalogue_no]...

it is linked to the project [MasterFixtureData]
with tables:
[tblFixtureCatalogues] (fields: [manufacturer], [catalogue_no]...),
[tblManufacturer] (fields: [Manufacturer], [rep_agency])
[tblRepAgencies] (fields: [rep_agency], [rep_contact],
[rep_telno]...)

the relationships are established like this:
[tblFixtureTypes].[manufacturer] to
[tblFixtureCatalogues].[manufacturer], one to many
[tblFixtureCatalogues].[manufacturer] to
[tblManufacturer].[manufacturer], one to many
[tblManufacturer].[rep_agency] to [tblRepAgencies].[rep_agency],
one to many
------

a form [frmScheduleEntry] exists with:
combobox: [cboManufacturer]
textbox: [txtRepAgency]

the data source for [txtRepAgency] is: query: qryRepAgency

qryRepAgency contains:
[tblManufacturer].[manufacturer], with criteria
[Forms]![frmScheduleEntry]![cboManufacturer]
[tblManufacturer].[rep_agency]
Expr1: [tblRepAgencies]![rep_contact] & (Chr(10)+Chr(31)+" -
"+[tblRepAgencies]![rep_telno]

behind the form's current event is: me.requery
behind the form's cboManufacturer is me.[txtRepAgency].requery



...... nothing updates

thanks in advance,
mark

 

[mark kubicki]

LOL (yes)
on my form, I want one field to update itself (automatically) based on the
value of another field on the same form...)

thanks
-m.

Could you describe in a sentence what you are expecting to happen that
isn't
happening?

I am working on a project with a linked table and need to create an
automatically updating field on a form of the active project with
information from the linked table
---this ought to be easy (I'm certain); but with my limited, self-taught,
lack of knowledge...

the active project is: [FixtureSchedule]
with table: [tblFixtureTypes]
having fields: [manufacturer], [catalogue_no]...

it is linked to the project [MasterFixtureData]
with tables:
[tblFixtureCatalogues] (fields: [manufacturer],
[catalogue_no]...),
[tblManufacturer] (fields: [Manufacturer], [rep_agency])
[tblRepAgencies] (fields: [rep_agency], [rep_contact],
[rep_telno]...)

the relationships are established like this:
[tblFixtureTypes].[manufacturer] to
[tblFixtureCatalogues].[manufacturer], one to many
[tblFixtureCatalogues].[manufacturer] to
[tblManufacturer].[manufacturer], one to many
[tblManufacturer].[rep_agency] to [tblRepAgencies].[rep_agency],
one to many
------

a form [frmScheduleEntry] exists with:
combobox: [cboManufacturer]
textbox: [txtRepAgency]

the data source for [txtRepAgency] is: query: qryRepAgency

qryRepAgency contains:
[tblManufacturer].[manufacturer], with criteria
[Forms]![frmScheduleEntry]![cboManufacturer]
[tblManufacturer].[rep_agency]
Expr1: [tblRepAgencies]![rep_contact] & (Chr(10)+Chr(31)+" -
"+[tblRepAgencies]![rep_telno]

behind the form's current event is: me.requery
behind the form's cboManufacturer is me.[txtRepAgency].requery



...... nothing updates

thanks in advance,
mark

 

[mark kubicki]

well with my first pass at getting it right...(unfortunately) "no".

- ..."derived" ? - it is just the value in a field where another field in
the same record matches a value on the form

- I tried entering as a data source for the control on the form
"=Dlookup...)" -maybe I got the format wrong...

- then I tried entering in the "after update" of the criteria control:
me.[txtRepAgency] =
Dlookup("[rep_agency]","tblManufacturer","[manufacturer]=me.cboManufacturer")

not yet... i'll keep trying,but I need to log off for today (thanks for the
direction)
-mark

--------------------------------------------------------------------------

Depending on whether the value to be updated is actually *derived* from
the
other value:

1. If it is derived, then use an expression for the control source of the
value to be updated that refers to the other value (e.g.,
"=[OtherValue]*10", or "=Dlookup(...Where x=[OtherValue])"

2. Create a procedure for the "AfterUpdate" action for the other field

Does this help?

LOL (yes)
on my form, I want one field to update itself (automatically) based on
the
value of another field on the same form...)

thanks
-m.

Could you describe in a sentence what you are expecting to happen that
isn't
happening?

:

I am working on a project with a linked table and need to create an
automatically updating field on a form of the active project with
information from the linked table
---this ought to be easy (I'm certain); but with my limited,
self-taught,
lack of knowledge...

the active project is: [FixtureSchedule]
with table: [tblFixtureTypes]
having fields: [manufacturer], [catalogue_no]...

it is linked to the project [MasterFixtureData]
with tables:
[tblFixtureCatalogues] (fields: [manufacturer],
[catalogue_no]...),
[tblManufacturer] (fields: [Manufacturer], [rep_agency])
[tblRepAgencies] (fields: [rep_agency], [rep_contact],
[rep_telno]...)

the relationships are established like this:
[tblFixtureTypes].[manufacturer] to
[tblFixtureCatalogues].[manufacturer], one to many
[tblFixtureCatalogues].[manufacturer] to
[tblManufacturer].[manufacturer], one to many
[tblManufacturer].[rep_agency] to
[tblRepAgencies].[rep_agency],
one to many
------

a form [frmScheduleEntry] exists with:
combobox: [cboManufacturer]
textbox: [txtRepAgency]

the data source for [txtRepAgency] is: query: qryRepAgency

qryRepAgency contains:
[tblManufacturer].[manufacturer], with criteria
[Forms]![frmScheduleEntry]![cboManufacturer]
[tblManufacturer].[rep_agency]
Expr1: [tblRepAgencies]![rep_contact] & (Chr(10)+Chr(31)+" -
"+[tblRepAgencies]![rep_telno]

behind the form's current event is: me.requery
behind the form's cboManufacturer is me.[txtRepAgency].requery



...... nothing updates

thanks in advance,
mark