Hi,

I've created a form which displays a customers details. I have Next & Prior buttons. Each time I skip to the next customer the grid updates displaying orders on file. The grid gets it's data from a local view. The only way I can get this to work is by setting the RecordSourceType property to 'Prompt' - is this correct? The manual gives the impression it is not but yet it's the only option which works.

It was working fine but then I must have changed something somewhere by mistake because now if there is one record found by the view the entire grid fills with the same record replicated. Any ideas?

Thanks in advance