Populate Form by Combo Box Selection, Editable?

[access_student]

Hi All!



I have created a database form that has a combo box which, when selected, shows invoice number & corresponding purchase order number for each record.

When an invoice number & purchase order is selected, the record matching this criteria will populate the textboxes on the form.

I have tried to set the control source for the textboxes to (for example) =[comboBox1].[column](0)
This works fine, but I am unable to edit the record... which is what I need to do!

I then tried to write an After_Update() like this Me.InvNO.Value = Me.comboBox1.Column(0)
I still can't edit the record on the form when it is populated.

Can anyone tell me how I can...
1. have a selection from a combo box that ...
2. populates the form...
3. and lets me edit the record on that same form after it is populated
??

THANK YOU!

[access_student]

Well.
It seems that by adding the code to After_Update() of the comboBox...
and then restarting Acces... the code finally worked, and I am able to retrieve & edit the records.

"The only thing consistent about computers... is that they are inconsistent!"