Using a text box in a form to update a specific record

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

Guest

Alright, what I am trying to do is make one form that can be used to
select/view records and update them or make a whole new record. I have a
combo box and a list box that enables the user to select the row they are
working on, and the list box then has an afterupdate code from the list box
to fill it with the date currently relevant on the row, but I am just using a
dlookup at this time and therefore I do not believe my data is actualy linked
to the row/column being displayed. I'd like to make it so if the user enters
data into any of the textboxes it changes the corresponding data on the
table, also I'd like it so the user could make a whole knew row, but I do
not want to use the built in new record slider that appears on the bottom of
the form, I've already disabled that.

Thanks.
 
I attempted to use Sql update in the after update event

It looked like this

update table
set value = [forms]![theform]![thetextbox]
Where rowparam = [forms]![theform]![listbox]

Both the text and list box are on the same form, but when I attempt to run
this form with this code in it, it errors that the table is already in use.
 
Back
Top