Hi, many thanks to everyone who responded to my question. I followed
Toby Bierly's suggestion and used the DLookup function in the
AfterUpdate event of the second combo combo box to select the relevant
fields from the Delivery Address table and poke them into the relevant
text box on the form. This works well and gives me exactly what I
want. Well done Toby, many thanks.
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/