Auto fill field

[Guest]

Is there a way to choose an item from a drop down box and have Access auto
fill in other fields?

Ex: Choose a job number from the drop down box and have Access
automatically fill in 2 separate fields with the start time and end time.

 

[Rick B]

Answered all the time. Very very common. Most often, someone will ask how
to pull down a customer name, and have their phone, address, etc fill in.

Do a search and you will find multiple methods to accomplish this.

Please search before you post.

Rick B

 

[Larry Daugherty]

Hi Terri,

In the AfterUpdate event of the combobox add the lines below with your names
replacing mine:

me!txtStart=me!cboMycbo.column(1)
me!txtEnd-me!cboMycbo.column(2)

Note that as you refer to combobox columns in properties the columns are 1
based but when you refer to cboMycbo.column(n) they are zero based.

HTH