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

D

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
Clearing combo boxes and a text box 2
Setting column width in a table with a macro is not working 0
How to edit data from a textbox on a form brought in from a combobox? 0
Dynamic Naming of Form Button 3
Link a text box based on drop down box with four options MS Word 365 0
Creating a Chart on form from selected data in query. 0
How to have two tables on same line? 1

Top