find and replace field value

[Guest]

I have a database that is supposed to populate a table with columns and rows:
Columns
A-M
and
Rows
1-50


I have a tblColumn and a tblRow and have created a field for
CellLocation:[Column]+[Row]. This value is actually the table location or
cell where the information needs to populate. I have been successful in
creating a pivot table which shows all the columns and rows correctly. I
have created an input form with the CellLocation and a subform containing the
information to go in that cell's space, but how do I find and replace the
CellLocation (col./row A1, C2, D5, etc.) with the information? I have tried
the findandreplace function, but am not having much luck. Could someone
point me in the right direction?

Thanks in advance.
L

Rows
1
2
3 to
50

 

[kingston via AccessMonster.com]

I may have misread your explanation but it sounded like you want to replace
the value in the field CellLocation. Unless the new value is a valid (and
probably unique) cell location, your pivot table and subform will fall apart.
Anyway, to replace a value in a table, use an update query:

UPDATE Table SET Field=Value WHERE Field=OldValue;

I have a database that is supposed to populate a table with columns and rows:
Columns
A-M
and
Rows
1-50

I have a tblColumn and a tblRow and have created a field for
CellLocation:[Column]+[Row]. This value is actually the table location or
cell where the information needs to populate. I have been successful in
creating a pivot table which shows all the columns and rows correctly. I
have created an input form with the CellLocation and a subform containing the
information to go in that cell's space, but how do I find and replace the
CellLocation (col./row A1, C2, D5, etc.) with the information? I have tried
the findandreplace function, but am not having much luck. Could someone
point me in the right direction?

Thanks in advance.
L

Rows
1
2
3 to
50