Andrew, this happens if you use:
- using combo boxes that have the bound column zero width, and
- the RowSource dependent on a value in the current row, and
- it's a continuous form or datasheet.
In this case, the combo's RowSource does not contain the display value for
the other rows, and since the bound column is not being displayed, you have
given Access nothing to display.
The workaround is not to hide the bound column, or not to limit the
RowSource. There are other fudges that involve including the table of the
combo's RowSource in the RecordSource of the form, so you can place a text
box on top of the combo to show the value. Messy.
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
Reply to the newsgroup. (Email address has spurious "_SpamTrap")
"Andrew H" <nospamwork> wrote in message
news:0a0901c3420d$1f2ff2f0$a101280aphx.gbl...> Hi ,
> When using a datasheet view on Subform. Everytime I move
> to the next record, my fields on the previous record which
> have the Requery Function Linkes to them, go blank.
> Is there a command I can input in to the VB code instead
> of or aswell as .Requery?
> i.e, show data in fields when not active record - type
> Would appreciate any suggestions on this.