A screen with two separate RecordSources?

[TOPSie]

I have two tables Customers and Transactions. I want to record a new transaction. So I am trying to design a single screen.



Left hand side are Customer controls bound to the Customer table. Typing in the name of the customer and the code finds the customer or detects this is a new one and fills in all the boxes for the Customer half of the screen.

Having got the customer details I want a set of controls to appear on the right of the screen with controls bound to the Transaction table, but all are empty (except the Customer ID) as this is a new transaction.

I thought I could use a subform - but this just seems to produce a list of existing transactions - which is not what I want.

I think that what I want is in effect two independent forms on the screen

Any pointers gratefully received

[Minty]

Just make you transaction subform set to Data Entry.
Then you will only be able to add new records.

[Micron]

I don't get the problem. These are mutually exclusive:

Typing in the name of the customer and the code finds the customer

or detects this is a new one

In the first case, would you not want to see the existing details? In the second case, there are no details based on what you typed/selected as a search, so no details. Then you need a way to add the base customer information first, then add the details. A subform should work fine in that scenario (if it is properly designed of course).

If you open the form as data entry, you won't be able to see existing main or detail data.