Simple Change in Database 1

[briglass]

I get an error when my Visual Basic project reaches this line:

dbNames![id] = idchange

it also doesn't like

dbNames![id] = val(idchange)

I must not be doing this right, any hints?

 

[jebry]

Hi!

We need a little more information. What is dbNames, [id] and idchange? It may be easiest to just post the code you have.

Jeff Bridgham
bridgham@purdue.edu

 

[briglass]

'(id is a field of the table Names)

set dbNames = db.OpenRecordset("Names", dbOpenDynaset)

inputchange = Val(InputBox("What number?", "Change", dbNames![id]))

dbNames![id] = inputchange

'or

dbNames![id] = Val(inputchange)


Make sense?

 

[jebry]

Hi!

Yes this makes sense, try this:

dbNames.Edit
dbNames![id] = inputchange
dbNames.Update

hth
Jeff Bridgham
bridgham@purdue.edu