SQL Control Reference

[DS]

When UPDATING, INSERTING, SELECTING or DELETING in Access with SQL is it
better to reference a Listbox field by placing the Listbox value into an
Unbound Textbox or by refering to it by column....such as
Me.Listbox.Column(0) also is it OK to use Me. in an SQL statement. Just
wondering?
Thanks
DS

 

[Rick Brandt]

When UPDATING, INSERTING, SELECTING or DELETING in Access with SQL is
it better to reference a Listbox field by placing the Listbox value
into an Unbound Textbox or by refering to it by column....such as
Me.Listbox.Column(0) also is it OK to use Me. in an SQL statement. Just
wondering?
Thanks
DS

Without some finagling you can't use .column from a query. And no, you can't
use Me in a query either. You can wrap a reference to a column in Eval() and it
can be made to work or you can have a hidden TextBox on the form refer to the
column and then reference the TextBox in the query.

All form references in a query have to be fully qualified like...

Forms!FormName!ControlName

 

[DS]

Without some finagling you can't use .column from a query. And no, you can't
use Me in a query either. You can wrap a reference to a column in Eval() and it
can be made to work or you can have a hidden TextBox on the form refer to the
column and then reference the TextBox in the query.

All form references in a query have to be fully qualified like...

Forms!FormName!ControlName

Thanks Rick
DS