Thread: Select Record in form by referencing Integar

Does anyone know how to select a record in a form by using an integar.

I can change a textbox to contain the record number by using the below code

me.text1 = me.form.CurrentRecord

But I can't change the record in the form by using a record number.

I would have thought that it would go something like the below but it looks like a 'Record' property doesn't exist. Anyone know if there is a way of doing this? I'm using Access 2002.

Me.form.record = text1.value

Thanks.

You need to use SQL or VBA with recordsets to update the underlying value. In general, a SQL statement will be easiest, something like this:

UPDATE your_table SET yourfield=text1.value WHERE table_id_field=record_id

You can execute this in VBA by using the DoCmd.RunSQL method.