microsoft.public.access

In Datasheet View, Ctrl+' should work. It does for me in all versions. I
cannot check Office 2007 right now.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Qawi" wrote in message
news:6E09FF3F-BACB-4FF3-9ADF-F151C133C267@microsoft.com...
> All, I have a table that has missing values for fields. I would like to
> know
> how to copy the contents of fields from a previous record to the current
> one.
> I attempted to do it in an update query but was unsuccessful. Also tried
> to
> create a macro that invoke <'> but that didn't work either. Any
> suggestions would be appreciated. The table has thousands of records so
> manually copying the fields would be prohibitive.