How to edit data from a text box brought in to a form through a combobox

[David]

Can anyone help me to be able to edit data on a form that I bring in
from a table through a combo box WITHOUT changing the data in the drop
down table? Once the data is selected, the information populates a
text box, but the user would like the ability to edit that information
on the new record ONLY without changing data in the combo table. I
have not yet discovered how to do this in the query. Thanks for any
advice you might have for me.

David

 

[Mark A. Sam]

David,

If the Rowsource of the combobox, meaning where it gets the list, is the
same as the field the combobox is bound to (controlsource) then this cannot
be done. What you need to do is use a different table as the Rowsouce. For
example, if the comboxbox controlsource is the field, [EmployeeName] and the
rowsource is [EmployeeName], you can't do what you want. You need a
different table which also has the field [EmployeeName]. This is called a
lookup table.

God Bless,

Mark A. Sam

 

[capecoralover239]

sorry but I don't know what to do