I'm using Access 2010 and developing a Database that is linked to SharePoint 2010. I'm currenty working on a Timesheet form.



On this form, I have a combo box that is linked to another table that contains various contract information. When a user selects a contract number in this box, I need 3 text boxes to populate with that contracts name, city and state.

I have added those 3 extra fields to my combo box lookup (Columns 3-5) and tried to populate them that way, but I can't since that method apparently doesn't work with web forms.

Any help would be appreciated.