Prev: Opening an Access 2007 form from Word VBA
Next: Are If statements possilbe in Queries?
From: Bird Byte on 3 May 2010 15:38
Hi. I have a 2 column combo box with a query for its row source. The query
includes one lookup table (2 fields: ID and Description), with the id
ascending. The bound column is one; column 1 is hidden.

If I open the form, choose a value from the combo box, go to design view,
then go to form view, the the combo box lists the last item that was
selected. Shouldn't the combo box reset back to the sort order? Can it be
made to reset?

Thanks for any help.
From: KARL DEWEY on 3 May 2010 16:29
You are thinking backwards. When you make a selection in the combo that is
bound it writes that selection to the record where it is bound. So opening
in design view and back again does not change the data you wrote to the
record.

--
Build a little, test a little.


"Bird Byte" wrote:

> Hi. I have a 2 column combo box with a query for its row source. The query
> includes one lookup table (2 fields: ID and Description), with the id
> ascending. The bound column is one; column 1 is hidden.
>
> If I open the form, choose a value from the combo box, go to design view,
> then go to form view, the the combo box lists the last item that was
> selected. Shouldn't the combo box reset back to the sort order? Can it be
> made to reset?
>
> Thanks for any help.
From: Linq Adams via AccessMonster.com on 3 May 2010 16:59
In point of fact, even if the combobox is UNBOUND, you'll see the same
behavior! Going from Form View to Design View then back to Form View is not
the same as closing the form then opening the form.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201005/1

 | 
Pages: 1
Prev: Opening an Access 2007 form from Word VBA
Next: Are If statements possilbe in Queries?