need table to update when a linked dropdown has information chosen

[Guest]

We are having a problem here. we have a table with linked fields.

we are trying to get 2 data fields to update when a user selects a record
from a dropdown field in the same table. so if they select record 5 and the
first name and last name are john and smith. we need the record to update
fname and last name field with john and smith.
is this possible?

 

[Peter Yang [MSFT]]

Hello,

I think you could do this via vba code using ADO object to update the
table.

Using ADO to Work with Access Databases
http://msdn.microsoft.com/library/en-us/odeopg/html/deovrusingadotoworkwitha
ccessdatabases.asp

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================


This posting is provided "AS IS" with no warranties, and confers no rights.