Fields with Data

[gary.newport]

I have created a form with two drop downs. The first is a list of colours and the other a list of teaching groups. The first combo limits the list of the second combo.

This all works fine and originally both combos were unbound. However, I want there then to be a control button that opens a form at the relevant record and the wizard will not list an unbound field. I therefore generated a simple query and made the control source equal to the relevant field of the query.

I set Show Only Row Source (the Row Source is based upon a SQL statement) and set Inherit Value List to No.

However, when I open the form a record from the query is shown in the field (I want the field to be blank).

Also, if I select a colour and then a group but change the colour I would like the group field to become blank again (to reduce an error occurring).

Anyone able to help?

 

[gary.newport]

Please ignore this! Never work on a database at the end of a long day and exhausted from a bad week!

All sorted out once I'd had a little sleep.