Textbox bound to Listbox column... How to edit data?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Grahammer (dont.spam_at_me.here)
Date: 10/27/04 

Date: Wed, 27 Oct 2004 08:23:28 -0600

I have a form that contains a listbox and several textboxes. When the user
selects an item in the listbox the details from that selection are shown in
the textboxes. I would like the user to be able to make changes in the
textboxes to update the data in the table to which the listbox is bound.

The listbox is bound to a table and only column 1 of the table is visible in
the list.

The textboxes are bound to various columns of the listbox, so when the
listbox selection changes, the textboxes automatically update.

The problem is that Access is not allowing me to edit the data found in the
textbox.

The form itself is not bound to any data at all.

Relevant Pages

  • RE: drop down and textbox
    ... there are simple methods and more complex method to do ... the are two different type userforms. ... I would recommend using a listbox for you drop down box. ... The textboxes and listboxes on the two toolbar are slightly different. ...
    (microsoft.public.excel.programming)
  • Re: Textbox bound to Listbox column... How to edit data?
    ... Listbox is also bound to the table. ... Textboxes are bound to the various fields of the table used by the form. ... form based on a unique key in the table. ... > listbox selection changes, the textboxes automatically update. ...
    (microsoft.public.access.forms)
  • Re: use multiple textboxes to filter a listbox
    ... a listbox (LstSearchOrders) ... I managed to filter the listbox with both textboxes ... Public txtSearchWO As Variant ... Private Sub TxtCity_Change ...
    (microsoft.public.access.formscoding)
  • RE: Error 2107 when setting the forms recordsource ?
    ... So when you go through the listbox on the left you see the fields change on ... The listbox gets filled by an SQL that filters all adresses by "A". ... The recordsource provides the values for record textboxes on the form ... The bad thing is that this doesn't trigger the listbox_AfterUpdate sub so I ...
    (microsoft.public.access.formscoding)
  • Why doesnt preselecting my listbox record from VB work?
    ... I have a form in Access 2002 with a listbox and some textboxes. ... form's record source is dependent on the listbox's selection. ... The form's Open routine requeries the listbox to bring it to life, ...
    (microsoft.public.access.forms)