Question: I have a subform which displays the results from a saved query.
Now I want to change to another query.

```
Me.SF_Results.Form.RecordSource = "NewQuery"

```

It works but the columns which were in the old query and are not in the new query are still displayed and show #Name? in every cell.

How can I update the columns for the new query?

I have found a solution here which involves setting the recordsource to an empty string and then to the new query, but it not working for me.
Also they use "Query.NewQuery" there for some to me unknown reason.

Answer: 
```
dependent: :destroy

```

is alternate syntax for:

```
:dependent => :destroy

```

It's [new in Ruby 1.9](http://nuclearsquid.com/writings/ruby-1-9-what-s-new-what-s-changed/#new-stuff-in-ruby-19).

`:dependent`, `:destroy` and `:bonus_card` are all [symbols](http://www.robertsosinski.com/2009/01/11/the-difference-between-ruby-symbols-and-strings/).
In Ruby, `:something` is a symbol. A symbol is a reference kept in memory and looked up quickly, so that it is a nice data type to use as hash keys. A Ruby Hash usually looks like:

```
{ :some_key => "some data", :other_key => 65536, :yet_another_key => :symbol_as_data }

```

Ruby 1.9 introduced a shorthand notation for writing the above, as long as keys are symbols, you can move the colon to the end and omit the fat arrow `=>`

```
{ some_key: "some data", other_key: 65536, yet_another_key: :symbol_as_data }

```

This is only valid for symbols passed as hash **keys** (also in hashes passed as method parameters). Other objects used as hash keys must still use the fat arrow(`=>`), and symbols used elsewhere are always written colon-first.