Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to fill in company name automatically upon choosing acct. no.

Status
Not open for further replies.

lenderb

MIS
Apr 4, 2005
3
US
When adding a new record, is it possible to automatically fill in the company name in the company field when the company's account number is chosen?
 
How do you choose the company Account Number?
Listbox/ComboBox?
here is a sample code for listbox. You need to change the Column index as per your list.
Code:
Private Sub ListBox1_AfterUpdate()
    Me.TextBox1.Value = Me.ListBox1.Column(0)
End Sub

________________________________________
Zameer Abdulla
Visit Me
Hold your child's hand every chance you get.
A time will come when he or she won't let you.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top