Subform/datasheet view

[Sue M]

Hi,

I have a subform on a form that displays as datasheet view
on the form. This is good, but I can't seem to change the
captions to what I want them to be.

The subform in design view shows as a form with textboxes
for editing in design view rather than giving the property
sheet with the list of field names like you get on a table.

Any changes I make to the textboxes don't come through on
the datasheet.

Is there a quick fix for this or will I need to recreate
the form & subform?

Cheers,

Sue

 

[Roger Carlson]

If you are going to use the datasheet view, you will have to base the
subform on a query and alias the field names.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L