How to populate info???

[Access Newbie]

Hi All

I'm building an invoice database so that Service Agents can log in and bill us for work that has been completed. When creating an invoice, the user must enter their companies ID. (AKA Servicer ID) In my database I have created a separate table containing details for each of our service agents. (Example: Servicer ID, Company Name, Address…) I want to set up the invoice form in such a way, that when the user enters their Servicer ID, the following field will display the company name.



Any ideas on how I can accomplish this?

[maximus]

There are many ways to do it. One of the most simple way to do this would be to use Column property of a combobox.

I will assume that you have a Combox Box whose RowSource is the table Which Contains Servicer Details.
(Example: Servicer ID, Company Name, Address…)

My first Column here is Servicer ID its index =0
Company Name its Index = 1
and so on

Now When I select an Servicer Id I want Company Name and Address to be automaticaly entered in text1 and text 2 on my form. so on the AfterUpdate event I will put this Code:
Me.Text1=Me.Combo1.Column(1)
Me.Text2=Me.Combo1.Column(2)

Here combo I is the name of the combo box in which you select the Servicer Id.

[revnice]

Maximus:

Would the invoice (or form) open blank when using that method?

I have a form that populates based on cus-num but there's always data in it when I open it.

I've tried setting the Data Entry parameter to Yes (which works) - but then the autopopulate functionality is defeated.

Thanks - rev