Unbound Control and AllowEdit = False

[mork]

I've got a form with AllowEdit = False.

On it is a tab control, one of the tab pages has an unbound listbox which
fetches data from another table.

I am unable to select items in the listbox.

Seems a bit odd that AllowEdit disables unbound controls. Is there a
work-around to this? Have I overlooked something?

(p.s. usings Access 2000)

--
email: my*****@canada.com // my_nick = mork

[Roberto Spier]

Maybe allowing edit on control's Keydown event , than, after update event,
disallow it.

Sorry for my poor english!
"mork" <my*****@canada.com> escreveu na mensagem
news:op**************@news.ss.shawcable.net...

I've got a form with AllowEdit = False.

On it is a tab control, one of the tab pages has an unbound listbox which
fetches data from another table.

I am unable to select items in the listbox.

Seems a bit odd that AllowEdit disables unbound controls. Is there a
work-around to this? Have I overlooked something?

(p.s. usings Access 2000)

--
email: my*****@canada.com // my_nick = mork

[mork]

Roberto,

Your solution is so simple it is brilliant! Best of all, it worked!

On mouse down: AllowEdits = True
On mouse up: AllowEdits = False

my doubeclick event even works.. it's very seamless to the user.

p.s. your english is fine!

--
email: my*****@canada.com // my_nick = mork

On Thu, 23 Oct 2003 14:24:53 -0200, Roberto Spier <fo*****@invalid.com>
wrote:

Maybe allowing edit on control's Keydown event , than, after update
event,
disallow it.

Sorry for my poor english!
"mork" <my*****@canada.com> escreveu na mensagem
news:op**************@news.ss.shawcable.net...

I've got a form with AllowEdit = False.

On it is a tab control, one of the tab pages has an unbound listbox
which
fetches data from another table.

I am unable to select items in the listbox.

Seems a bit odd that AllowEdit disables unbound controls. Is there a
work-around to this? Have I overlooked something?

(p.s. usings Access 2000)

--
email: my*****@canada.com // my_nick = mork

[Steve Jorgensen]

If you are in Access 2000 or above, you can get the behavior you are
looking for by leaving AllowEdit = True, and either setting the form's
recordset type to Snapshot or adding Cancel = True to the form's "On Dirty"
handler.

In Access 97, the Snapshot method works, but you can't use the On Dirty
technique because that event handler was not yet available. The Snapshot
method is fine for small result sets, but will be slow for large ones.

On Thu, 23 Oct 2003 02:04:41 GMT, mork <my*****@canada.com> wrote:

I've got a form with AllowEdit = False.

On it is a tab control, one of the tab pages has an unbound listbox which
fetches data from another table.

I am unable to select items in the listbox.

Seems a bit odd that AllowEdit disables unbound controls. Is there a
work-around to this? Have I overlooked something?

(p.s. usings Access 2000)