Field Default

[darryaz]

I'm working on a database for an MBA class. The data is mainly information about people: names, birthdates, addresses, etc.

I am displaying a photo of each person on that person's form. In order to do this I have to enter the path of the photo (example: r:\images\123456.jpg) into the IMAGEPATH field.

The filename of the photo is always r:\images\IDNO.jpg (where IDNO indicates the primary key of the database).

Is there a way to make r:\images\IDNO.jpg the default in the IMAGEPATH field?

 

[vbaInet]

Yep! Set the Control Source of the Image Control to:

="r:\images\" & [IDNO] & ".jpg"

 

[darryaz]

Thanks, worked like a charm!

 

[vbaInet]

Happy to hear!

Welcome to the forum by the way.