Hi,

I am trying to create a form for viewing information rather then entering. For this I would like to have a drop down list box (combo) and then say 5 other values will be automatically looked up.

I have tried using a prompt at the start of the form but this just works the one time. Gives me all the info but then if i select another value in the drop down box it does not update the other fields.

Any ideas on how this can done ?

Cheers,

Waynef

Waynef:

Remember that Option 3 of the wizard? That's your ticket.