M
msNews
I am upsizing a Access 2000 Database to SQL 2000 and I have a problem with
creating a parameter query in SQL.
In Access Code I do the following: Me.RecordSource = "SearchQuery"
where
"SearchQuery" = Select JobNum from Jobs where JobNum =[Forms]![Job
Entry]![Account#]
and I need to change this to a parameter query in SQL Server and pass the
information and I am having
problems.
Thanks
creating a parameter query in SQL.
In Access Code I do the following: Me.RecordSource = "SearchQuery"
where
"SearchQuery" = Select JobNum from Jobs where JobNum =[Forms]![Job
Entry]![Account#]
and I need to change this to a parameter query in SQL Server and pass the
information and I am having
problems.
Thanks