Hi All
Is there any way of generating a Caption Field to change depending on the response of a user or to pop up the autonumber field in the caption field

Thanks

Brendan Bartley

__________________
Brendan Bartley

I am not sure what event you want to do this with. Can you explain more of what you want?

You can take a value from anywhere like this, and then make it part or all of your caption, like this:

sValue = InputBox("Please enter a value"

Me.Caption = sValue

HTH

mmcdonal

that should be:

sValue = InputBox("Please enter a value")

mmcdonal