how to get one field to automatically set another?

M

mahubbard

I think this is done through a macro, but I can't get it
to work.

We have several linked tables. One is a set of maintenance
activities, with info of "activity", "unit", and "cost per
unit". Another table is maintenance records.

When you select "fix gate" from the "maintenance activity"
listbox on the maintenance records table, we want
the "units" field there to automatically switch to "EA",
and the cost per unit to be filled in. Then when
the "Amount" field is filled in, it should update the
estimated cost (amount x cost per unit). If you
selected "pour concrete" it should show "CY", and the
related info for pouring concrete should pop up to be
calculated.

I've tried setting up a macro but must be doing something
wrong. Any ideas? Thanks!

mahubbard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HowTo?:Entry in one table to refer to another and autoupdate other fields? 1
Updating Fields in One Table Based on a Field in Another Table 1
autopopulate 2
Newbie to Access - updating a field with a calculation 1
Automatically populating a field. 6
Update one field from one table to another field in another table. 2
Adding data to table that retreives data from another table 2
How do i relate one field to another within a single table? 1

Top