access 2002 transactions

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

I've been trying to use the transactions feature of
access 2002 in an application I'm making. But am lost on
how to manage the parent child link between the forms.

My last attempt was to use a qry to populate the sub frm.
I adjusted the criterion on the qry to filter for the
field of the main frm. Only problem is that field on the
main frm is an autonumber field. And the qry then asks
for the missing parameter. Which doesn't do any good in
the end.

How do I manage this??? Please email me directly and let
me know. (e-mail address removed)

Patrick
 
I've been trying to use the transactions feature of
access 2002 in an application I'm making. But am lost on
how to manage the parent child link between the forms.
Click to expand...

Are you using a Subform control on the mainform? If so, simply set the
Master Link Field to the name of the primary key of the "one" side
table, and the Child Link Field to the foreign key in the "many" side
table. No code and no query are needed.
My last attempt was to use a qry to populate the sub frm.
I adjusted the criterion on the qry to filter for the
field of the main frm. Only problem is that field on the
main frm is an autonumber field. And the qry then asks
for the missing parameter. Which doesn't do any good in
the end.
Click to expand...

You're evidently not using a Subform, and you're making the task more
difficult than it needs to be! If for some reason you need a separate
popup form, you can base it on a Query with a parameter of

=[Forms]![firstformname]![controlname]

referencing a control containing the link field.
How do I manage this??? Please email me directly and let
me know. (e-mail address removed)
Click to expand...

Done... but two warnings:

This request is considered rather impolite. This is a public,
peer-to-peer newsgroup; those of us who volunteer our time to answer
questions all prefer to post the answer so that others can benefit.
Private EMail support (in my case) is reserved for paying clients.

Also, the Swen virus is still out there. Posting your real EMail
address in a newsgroup message *WILL* cause it to be harvested by
spammers and by virus-infected computers. If you start getting
hundreds of EMail messages purporting to be Microsoft security
upgrades, delete them unopened - they're a virus. It's too late to
remove your address from the newsgroup though.
 
Back
Top