Refer to specific records on a continuous form

[Drenda]

Hello

Is there any way I can refer to specific reocrds on a continuous form so for example I have a form with a control called "building name" based on a table with ten records. I would like to refer to "building name" on a specific record in the continuous form

Thanks

 

[MajP]

You need to add a little detail of what you are trying to do. There is not a "record" object like Excel has a Row object. However there are lots of ways to return the value of "building name" for the Nth row. One way is to use the recordset or recordsetclone property of a form. You can then move to the Nth record and return a value.

 

[lameid]

Only one record has focus at a time so technically no.

You can do things to navigate records in order to select a record or you can use a query to get the same records to do something else with them.

It all depends on what you are trying to accomplish.

 

[Drenda]

Okay

Thanks I'll have a go with the query and see how I get on