How to add static labels to form

Hello there,

I have a Company table and Order table. While showing the Order form I want the company information to be displayed at the top and should be static. How do I do it?

Regards,
Piyush

What type of Form are you using? You should be able to add a label from the toolbox and either type
in the text or change it to a textbox and assign the controlsource to one of your fields in
your company table.

Thanks this works fine when the DataEntry property of form is set to No i.e. the form opens in edit mode. But when it's set to yes then I get those textboxes blank and as soon as I enter a record they are filled.

If you form is being presented in a DataSheet view for data entry then you can not do it
this way. You need to set up a main form with the static lables on it and an area for a subform.
This subform will be the DataSheet data entry form so to speak.

Great thanks