Display Table info in Text Box

[ChrisDo11]

The company i work for runs many contrcution projects. Each project has its own database.

In each database there is a table with the project information including the following fields;

Project Name
Project Number

Because each project has its own database there is only i record in this table.

i want to create a form based on another table within this database but i want to have the form display the project name and number in a text box. i have no idea how to do this.... i have tried the following code in the control source but no luck....

thanks for any help.

Control source
=(

![project information].[file name])

 

[Mile-O]

Set the form's RecordSource to the table you want information from and then set the ControlSource to the field you want information from.

 

[ChrisDo11]

i have the forms record source set to another table. i need the information entered into this form stored in this other table.

 

[Mile-O]

What about just using a subform and making it look as if it's part of your main form if all you are wanting to do is display the details?

 

[ChrisDo11]

i think i can get that to work.
\
thanks.