Display data from 2 different tables in one form

[CJ_London]

I'm still not clear on what you are trying to do but it sounds like you just need to make the recordsource of the form the name of the table

 

[awade]

I have one table the same format to that attached in the first post of this thread. I would like to display the data from that table in the same format as achieved previously. (One Form with 4 subforms, 1 for each engine) I have used the same format as before but can not get any data to display.

I have done the same steps as last time but cant get any data to display on the 4 sub forms. But I have directly dragged the information from the table onto a form, and bought 4 of those forms onto a master form. The only difference is that I haven't run it through a query with the IND function.

I have a Combo Box in the header looking up Tail Numbers directly from the table. [Tail Number]

Each sub form has Link Child Field set to Tail Number and Link Mater Field set to P1, P2,P3,or P4 depending upon which box it is.
I have a text box behind each sub form with the Control source set to =[Tail Number] & "1".."2"..."3"...."4"

Cheers

 

[awade]

Hi,


I'm not sure where you are getting the AF hours etc information, but we can modify the combo query to bring that through if required

See how you get on

Good Morning All,

I have been able to get this form working, but I now to to get additional information from the query onto the main form (AF Hours, date last updated, APU S/No)

Can anyone help in getting this data across.

Cheers