[AccessD] Datasheet subform showing "Error"

[Borge Hansen]

David,
I would have a look at that particular stored procedure in the SQL backend
to see how it behaves with the null parameters. Perhaps the issue is with
the SP and its initial parameters?
/borge

On Wed, 25 May 2022 at 8:38 am, David McAfee <davidmcafee at gmail.com> wrote:

> Hi all, long time no post. :)
>
> I'm  working on a project for a company that we're merging with.
>
> It's an old Access 2010 ADP connected to a SQL 2000 DB. Some old, isolated
> legacy set up that they need a new screen to do some maintenance.
>
> I made a foem with a datasheet subform.
>
> The main form is unbound with text and combo boxes, wose values are used
> for input parameters.
>
> The subform is bound to a stored procedure. The procedure returns all nulls
> as default when the input parameters are all null, such as when the form is
> opened.
>
> When the parameters are chosen on the parent form and a command button is
> clicked,  I simple call: me.mysubform.requery
>
> This works for other forms. This form, for some reason returns "#Error" in
> almost every field. The correct number of rows are returned and the PK &
> GLAccount columns are displayed, but all text columns have the Error.
>
> I can hit F5 and nothing changes. But if I switch to design view and come
> back k to form view the data is displayed correctly.
>
> From here on out and I change parameter values and click the button and it
> all works as expected. It's just that initial requery that returns errors
> in the fields.
>
> Any ideas?
>
> Thanks,
> David
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>