Can code refernce a Row in a table

[tmccork]

I am trying to find a way set a textbox on a form = to a recordsource row and colum. Or a work around so that if the records change the boxes will change. Any Ideas welcome

Thanks

Terry

 

[Rolliee]

Suppose I have a field in the form's data named [LName1]and [FName1]

I want to put them in a text box named txtAllName

Open the properties of the form and use the OnCurrent Event with the following Code.

me.txtAllName = me.FName1] & " " & me.LName1


rollie@bwsys.net

 

[tmccork]

Thanks Rollie, I am not sure that I explained my problem. I have a form that I would like to have multiple records on, for instance records 1-5. Each record has five fields, [RecordNum], [Name], [Frequency], [Date1], and [Date2]. The [RecordNum] field will change as well as the others so I would like to reference the Row Number.

I would like to have Record 1 fields = Row 1 fields in a Recordsouce, Record 2 fields = Row 2 fields, ect.

Something like
Me![Name] = rst!(input code for row1 [Name])
Me![Frequency] = rst!(input code for row1 [Frequency])
ect.

I have also thought about the find next function but am not sure how that would be done. Thanks for any help

Terry

 

[Rolliee]

use the wiz to show you how. It sounds like you want a database view. If your 'rows'- the correct term is records - are tied to some other field variable, use a subform.

rollie@bwsys.net