>Naomi,
>
>First of all thank for your help.
>
>The macro substitution is because the sql view name varies as access from the network the username will be created as the view name.
>
>The error message is this..."Can not insert an empty row from a view or cursoradapter into its base table(s)". although the buffering mode is set to 5
>
>Rgds,
>
>Ed

Hi Ed,

You still don't need macro - use name expression. Just try the code I posted - it should work and it assumes a variable inside SQLView.

Your error means that somehow you either trying to insert an empty row or didn't specify the KeyField.

Can you post your CA definition, please?