Displaying the content of two fields in one.

[donrichy]

Is it possible to display the content of two fields in separate tables say Tab A and Tab B in a separate field in Tab B. Eg.in Tab A there is a field known as "Short code - text" which displays e.g. AAN and a field in Tab B called "ID - Autonumber (format 0000)" e.g. 0001.(There is one - many relationship between Tab A and Tab B). I want to display "AAN0001" in the field "Project No." in Tab B.
Can this be done.

 

[John Big Booty]

Your Form can only be bound to one table, so you will need to use the DLookUp() to collect the related data from your second table.

You could then concatenate your two pieces of data in an unbound text box, using Control Source along the lines of;

=Me.YourFieldOnForm & DLookUp()

 

[John Big Booty]

Sorry my bad perhaps I should have said;

Your Form can only be bound to one table/Query, ...

However I do take you point