need table to update when a linked dropdown has information chosen


G

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?
 
Ad

Advertisements

P

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.
 

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

Top