By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,564 Members | 804 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,564 IT Pros & Developers. It's quick & easy.

Access 2000 upsized to SQL Server problem passing value from Form to Query

P: n/a
I used the upsize wizard to change my Access 2002 database to a SQL
Server ADP project. I had a form where the user entered a value into a
text box and when a command button on the form was clicked a Report was
opened. The reports record source is a query. The query uses the
value from the form text box to restrict the query.
Table name = EggsTable
one of the columns in the table is named: EggColor
Form name = EggColorForm
Form text box name = ColorTextBox
the OLD sql query is:
SELECT EggsTable.EggColor
FROM EggsTable
WHERE (((EggsTable.EggColor)=[Forms]![EggColorForm]![ColorTextBox]));

This no longer works. Does anyone know how to change the syntax to get
this to work? Or do I need to do something different, like function or
variable, etc.?

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I also tried just opening the report with the report's Server Filter
property set to:

EggColor=N'Forms.EggColorForm.ColorTextBox'

but that didn't work either

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.