By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,193 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,193 IT Pros & Developers. It's quick & easy.

Maintaining a Field Value When Switching Between Subforms

P: 1
I'm currently making a database for a research project and I keep running into a problem. I have one master form with the tab control and several subforms. Each subform is backed by a table that are all connected by a single field "Accession Number". As I switch between subforms, I would like the subform to show a record with the same Accession Number as the previous subform. If that does not exist, to show a blank record with the previous subform's Accession Number filled in already. Adding this in would help my database to flow really nicely. By avoiding having to re-enter the Accession Number on each subform, I should be able to fill in and access the information pretty simply. I'd super appreciate it if anyone can help!

Aug 15 '08 #1
Share this Question
Share on Google+
1 Reply

P: 23
You need to Link the Forms with the Common Number. You can find good examples for similar situations in the Northwind.mdb database.

Open the Customer Orders Form or Orders Form which have linked Sub-forms in them.

Click on the Sub-Form and display the Property Sheet (View - -> Properties) and look at the Link Child Field, Link Master Field Properties.

a.p.r. pillai
** Link Removed **
Aug 15 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.