"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

 

[Pat Hartman]

When you have fields on a form that you do not EVER want to allow updates for, set the field's Locked property to Yes. You also might want to set the TabStop property to No. This won't prevent a user from clicking into a field but he won't be able to tab into it.

If the top and bottom halfs of the form are actually a single form bound to the same query, just create additional controls and lock them.

If there are multiple subforms involved, you may need to change the queries of the subforms to they include joins to the lookup data that you want to "duplicate".

PS - Forms are not optimized for printing. You'd be better off creating a report.

 

[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.