Can you synchronise data using 2 'on-current' commands?

B

Bridget

I would like to set 2 'on-current' commands, so that I don't have to manually
type in ID/Ref NOs into a form and its companion sub-form. I have one link
set up which works, but I want to automatically display the other ID too.
(I'm doing a competitor database with forms for Provider, Curriculum Area,
Courses Offered, and Modules offered. The Curriculum form is linked by
Provider ID, but the Courses Form is linked to Curriculum Form by Curriculum
ID (so far so good) but, I want the Provider ID to show up automatically on
this form too, and don't know if it's possible or how to do it! Ditto, I'd
like the sub-form about Modules to also display the Provider ID
automatically, without having to add it manually. I have tried all sorts of
ways to link on IDs and this setup is the only one that works.) I'm not a
novice at Access but know what I know if you see what I mean and am a bit
rusty too! Can anyone help? Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top