By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 927 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

Unbound Control and AllowEdit = False

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

P: n/a
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)


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.