PLS HELP~! Simple Question: Master & Child Link without subform

[Kaoli]

Good day everyone.
I appreciate any suggestion by all of you.

1st Is possible have Master & Child Link function without adding any
subform? If yes, how?

Eg: When I selected a customer "ABC Inc" from a combolist (or many more than
1 field; eg this month,sales man A and etc), all transaction record from
table tbltransaction will show me all transactions in a ~*SPLITFORM*~
according what i selected, when I adding new record in the form the table
tbltransaction will automatic adding new record including all
selection(customer ABC Inc,sales man A and etc) I make which like how parent
form and subform do between master link and child link.

I did not use subform for this because I unable to add Splitform in a
subform, I search many place but cant found the best solution,

I try to mimic splitform in 2 subforms(1 single form and 1 datasheet), I can
synchronize between single view subform and datasheet subform, but I facing
problem when I adding new record and delete record and other few small
problems. What I can say is not a new user can simply done this without a
good VBA knowledge, as my problem is very simple so I hope I can mimic
subform function in Splitform, so I do not need to write many VBA code for 2
subforms(1 single form and 1 datasheet) or maybe someone can teach me how to
write the VBA code which allow me mimic splitform in 2 subform.

I tried to solve and search solution in internet about 2 months, I really
hope anyone can help me this new user to solve this simple problem.

 

[KARL DEWEY]

If I understand what you want I think if you Left Join Master to Child in the
query it will function like you want.

 

[Kaoli]

May I know what you mean left join Master to Child in the query?

 

[John Spencer]

In the underlying query
There should be a link between the two tables ( a line from customer id to
customer id - or whatever you call the field identifying the customer).

Double-click on the line and choose the option that shows all customers in the
customer table and matching records in tblTransaction - option 2 or 3
depending on how the relationship was set up.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County