"Echoing" a field on a form as View only

[Patfreem]

Hi All,
On my form I would like to 'see' fields from another table without allowing editing. This form is printed then cut in half - Both the top half and the bottom half show the fields I want to 'echo' [I'm sure there's a proper term for this]. How can I do this and protect the data in the parent table?

Thanks!
~Pat

 

[missinglinq]

If the Fields 'from another Table' were to be included in the Record Source for your Form, i.e. if you created a Query to include Fields from both Tables, chances are none of the Controls would be editable, as most Multi-Table Queries are Read-Only.

The usual way to retrieve Fields from a Table or Query that is not part of the Record Source is to use the DLookup Function, with a 'Where' clause to identify the particular data needed. This would require a common Field between the two Tables. Does such a Field exist?

And just to re-iterate, Forms are not really meant to be used for printing, Reports are. And if you used a Report, you could use a Query to join the two source Tables, as editing would be a moot point!, at this point in time

Linq ;0)>

 

[Patfreem]

Hi Missinglinq,
Regarding DLookup - Yes I do have a common field. In fact it's the field I want to use as a Combo Box. The plan is to use the Combo Box choose the record in the other Table, and I suppose the DLookup to return another field in that record i.e. The Combo Box on the Form looks up a Job#, and DLookup field returns the "Job Name" associated with the Job#. Both Fields are in the same Table.

+1 to using a Query + Report! I'll get this Form stabilized (it's the last one on the Customer Forms List), then go learn about Reports.