image change on continous record forms

[jer]

Ihave a form which shows all tools in a box. I have images that change with each tool record. However when i put the form on continous view only the image of the first record appears across all records!! any ideas? Also is it possible to have the form in single form view but press a button that print all the records as if the form was in continous form view?
Any help would be great!!
Jer

 

[vbaInet]

You are doing it through the VBA editor so it won't work that way in a Continuous form.

As for your second question, you will need to

1. Open the form in design view
2. Set the Default View to Continuous
3. Close your form with acSaveYes option.
4. Reopen your form and print
5. Repeat steps 1 to 3 and switch back the default view to the original value.

 

[jer]

so is there anyway of having the images change in respect to the record when the form is in continous view??

 

[vbaInet]

The following link should give you some pointers:

http://office.microsoft.com/en-us/a...s-forms-reports-and-controls-HA001147204.aspx

If the images are saved on your hard drive (which is the preferred method), you simply set the Control Source of an Image control to the Full Path of the image.

 

[Simon_MT]

You can do this:

I have a control called ImageFile: =[Forms]![Menu]![Image Directory] & [Thumbnail File]

The Menu form determines where the images are stores and the Thumbnail File determines the actual Image to use.

Then the ImageControl Control source =[ImageFile]

This works for Access 2007

Simon

 

[jer]

Thanks for the help!!