Select Record in form by referencing Integar

[danny2000]

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

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

Thanks.

[davegugg]

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:

Please Login or Register  to view this content.

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

[danny2000]

Dave, thanks very much. Good solution too.

I'll definitely use that. Thanks again.