Re: FN-FORUM: Access Problems

date posted 6th August 2004 14:19

Look at the Northwind code samples, what you want to do is there. I found it
years ago on Access 2 or 7, when we were switching from DataEase (since
that feature was built in - no code). But I only do Access Intro courses,
so I promptly forgot again. Something like: combo box with 3 cols to pick
supplier and an after_update event in supplier field.

Private sub combo_wotsit_afterupdate()
Me.supplierurl= Me.comboboxid.Column(1)
Me.suppliercontact = Me.comboboxid.Column(2)
End sub

Or use a dlookup as in http://www.mvps.org/access/forms/frm0009.htm

CAVEAT I am not a developer
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Kathy
http://www.vendetta.co.uk
+44(0)7005 982 261
DNRC Minister for Useful but Irritating Information and Trivia
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

----- Original Message -----
From: "John Murphy" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Friday, August 06, 2004 1:38 PM
Subject: FN-FORUM: Access Problems


>
> Hey all
>
> I'm building an application in Access to keep track of products I have
> cost and where they come from now I want to be able to do this....
>
> Instead of typing in the same supplier, url and number in each time
>
> I want to be able to pick the Supplier from a drop down and it adds the
> URL and Contact number in the valid fields. Any ideas?
>
> John
>
>
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>