Two subforms

I recently created a main form in the style of the customer order form in the
Northwind database. It has two subforms and I've linked them together so when
you click on a line in the first subform, the relevant records appear in the
second.

This is a very convenient way for me to look at my records. What I was
wondering is this: is there any good reason why I shouldn't use this method
for data entry? I've tested the forms and everything seems to work ok.

I just wondered why none of the books seem to suggest this method (or at
least the ones I've read!). Thanks in advance.

It is a perfectly valid method for data entry. I've used that method for
years. I usually put a delete control on the right SubForm so a single record
can be deleted. It is important that you have Referential Integrity enforced
so there are no orphaned records.

C Tate wrote:
I recently created a main form in the style of the customer order form in the
Northwind database. It has two subforms and I've linked them together so when
you click on a line in the first subform, the relevant records appear in the
second.

This is a very convenient way for me to look at my records. What I was
wondering is this: is there any good reason why I shouldn't use this method
for data entry? I've tested the forms and everything seems to work ok.

I just wondered why none of the books seem to suggest this method (or at
least the ones I've read!). Thanks in advance.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200804/1