Re: editing current record

From: Marshall Barton (marshbarton_at_wowway.com)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 14:04:18 -0600

Penny George <Penny George@discussions.microsoft.com> wrote:

>My form is set to "continuous form view" so I can see multiple records at
>once. It queries a database to display this information. The problem occurs
>when I try to add a new record and manipulate the data in a drop down box.
>All the data disappears for the old records. ( It is not deleted from the
>table but it no longer displays on the screen.) Essentially I am trying to
>modify the control source of just the record being modified on the screen and
>make the data in the drop down box reflect the input from another field on
>the form.

There is only one set of properties for a form control.
It's just displayed multiple times in continuous (or
data***) view. This means that you can only get what you
want by playing a devious game with a **bound** control.

Place a text box (bound to the appropriate field) directly
on top of the text portion of the combo box. Now you can
manipulate the combo box's RowSource without changing the
appearance of the other records.

To allow the user to click/tab to the combo box, set the
text box's GotFocus event procedure to immediately (re)set
the focus to the combo box. When the combo box receives the
focus, it will automatically be brought in front of the text
box and behave normally. 

-- 
Marsh
MVP [MS Access]