ADDING A VALUE TO A TABLE

[FontanaS]

I WOULD LIKE TO ADD A VALUE TO A COLUMN IN A TABLE.


SO FAR I HAVE:

TABLE!TBL_ONE.CITY = "LAS VEGAS"

BUT I KEEP GETTING AN "OBJECT REQUIRED" ERROR.

THANKS

 

[Chance1234]

where are you trying to add it from , code ? a form ? a macro ?

 

[Chance1234]

hit enter to soon, if its a form and the form is bound to the data then it would be

me.[city] = "las Vegas"

 

[FontanaS]

THE FORM IS NOT BOUND TO THE DATA.

I JUST HAVE A BLANK FORM AND A TEXTBOX.

I DON'T WANT TO LINK IT TO THE TABLE BECAUSE I DON'T WANT THE USER TO BE ABLE TO VIEW ANY OF THE RECORDS THAT ARE ALREADY IN THE TABLE

 

[Chance1234]

you can bound the form and have it as data entry only look in help in Access 97 on hwo to do this

or ..


dim mydb as database
dim myrec as recordset

mydb = currentdb()
myrec = mydb.openrecordset(TBL_ONE)

with myrec
.addnew
![city] = me.txtcitybox.value
.update
end with

mydb = nothing
my rec = nothing