A Report from 2 Forms

[leo31]

Hi

I have 1 table (Sales) being displayed by 2 Forms (Customer Sales & Customer Sales Other).

1 form (customer sales) is embedded in as a subform in a form called Photos, and the other is embedded as a subform in a form called Customers.

From the Customers Form I create a report using a query on the sales of that customer based on an order number.

This works well, it gives me a categories list showing customer, order no, address etc... and then lists

Description, Price, & Qty.

The problem is this.
I want to add the field PhotoTitle listed in embeddedform Customer Sales In Form Photos to the report, which I can do, but when I do this, it only show the Customer Sales entries, and ignores the Other Sales entries, as that field doesnt exist there. The reason is it ignoring them, is that I am concatenating the Description field & Photos.PhotoTitle field.

The statement that causes it to fail is in an unbound label in the report =[Description]&" "&[Photos.PhotoTitle]

Can I get it do to this but pull the info from both locations, ie, If PhotoTitle is null or doesnt existing then ignore but still show entries from both locations, sort of thing

I've tried adding the field to the Other Sales table, but of course it is not Photos.PhotoTitle and doesnt work

Any ideas? Thanks

 

[Rabbie]

If you base your forms on queries rather than directly on tables this should make things easier. From what you say you need to look at your basic design because normally all sales would be in the same table.

 

[leo31]

I think actually the Other Sales form maybe based on a query, I'll check it, and if not change it.

All the Sales are in the same table, but are being displayed by 2 forms, one relates to Photos, hence has the PhotoTitle Field the other relates just to Customer, so doesnt have the field.

I'll check how the Other Sales is being created.

Thanks this might help