Update another table from a form

[Guest]

Hi,

Please help. I have a :
- Table which stores appointed brokers tblBroker (BrokerID, BrokerName)
- Form F_BrokerTransaction (cbxBrokerType, cbxBrokerID, txtFee and
cbxProjectID) to capture all transactions and store data in tblTransaction.
- Table to track broker history, tblBrokerHist (HistoryID, BrokerID, Fee and
ProjectID).

If cbxBrokerType in F_BrokerTransaction is "Appointed", I wish to have
tblBrokerHist to be updated with the BrokerID, Fee and ProjectID (apart from
normal updating in tblTransaction). How do I do this?

I've check all the discussions and MS Assistance
(http://support.microsoft.com/?kbid=209728) but I don't want to use an update
query. I want the update to be done automatically each time the transaction
is by appointed broker.

Appreciate any help I could get. Thanks a lot.

 

[Arvin Meyer [MVP]]

There are no Triggers in Access which work directly on the data in the
tables. No file server database has Triggers. To do this in Access you would
need to work directly from an Access form, using the AfterUpdate or
AfterInsert event to run an update query (or use sql or VBA code to run the
update) to fill the second table. If you want to do it at the table level
directly on the server, you will need to use a server based data engine with
Triggers, like SQL-Server.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access