updating fields in to a form using drop down item record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a form with text box fields. When using the forward and back
navigation buttons the user can move through the records in Table A

One object on the form is a listbox which is loaded through table B

I would like it so that when the user selects an item in the list box it
loads the form text box fields with some of the columns in table B.

It also automatically updates Table A with fields from Table B.

The reason is so that users can get default data and then edit it later.
I have no need to set up a relationship between table A and B to perform
lookups.

Thanks

Chris
 
Chris said:
Hi,

I have a form with text box fields. When using the forward and back
navigation buttons the user can move through the records in Table A

One object on the form is a listbox which is loaded through table B

I would like it so that when the user selects an item in the list box it
loads the form text box fields with some of the columns in table B.

It also automatically updates Table A with fields from Table B.

The reason is so that users can get default data and then edit it later.
I have no need to set up a relationship between table A and B to perform
lookups.
Click to expand...


Use the Column property:

Me.textbox3 = Me.listbox.Column(2)

to copy the **third** column in the list box's row source to
a text box.
 
Back
Top