VBA Code

[Blethyn]

Hi

I need to be able to have a button on a form that when clicked, it updates a boolean field in the relevant record.

I bought a book to help me with the recordset code etc but i must be doing something wrong because it doesnt seem to work.

First it said to create a reference by selecting Microsoft Active X Data Objects 2.7 Library which i did.

Then it said to create a data source by going to the control panel/administative tools/data sources, which i did.

Then i tried an example of simply opening a recordset by using the following code:

dim rs as recordset

set rs =CreateObject("ADODB.Recordset")

rs.Open "[tablename]", "[DataSource]"

I did this and various other things that it suggested but there was always an error at runtime.

Any suggestions?

Thanks

[Rabbit]

Just have a boolean field as a checkbox on the form and you don't have to worry about code at all.

[NeoPa]

Hi

I need to be able to have a button on a form that when clicked, it updates a boolean field in the relevant record.

I bought a book to help me with the recordset code etc but i must be doing something wrong because it doesnt seem to work.

First it said to create a reference by selecting Microsoft Active X Data Objects 2.7 Library which i did.

Then it said to create a data source by going to the control panel/administative tools/data sources, which i did.

Then i tried an example of simply opening a recordset by using the following code:

dim rs as recordset

set rs =CreateObject("ADODB.Recordset")

rs.Open "[tablename]", "[DataSource]"

I did this and various other things that it suggested but there was always an error at runtime.

Any suggestions?

Thanks

Your code seems to use concept names instead of actual item names.
I doubt you actually have a table called [tablename] for instance. Having said that, you really would be well advised to follow Rabbit's advice and do it via a form easily with bound items.
We can help with that too if required :)