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

Setting the default value in a subform

P: 6
I have a 'Creator' form, and within this is a 'Reports' subform where you can scroll through all of the reports that the creator has made.

On my reports form I have a button that opens another 'Change' form that allows you to change the creator of the current report. However, I cannot get this 'Change' form to display the report that is currently open when it loads.

In the 'Change' form I have a textbox which I want to display the title of the current report, then I have a dropdown menu displaying all of the possible creators' names to change to.

My problem is that when this 'Change' form opens, it is always on the first record/report. How can I get it to load the current report/record?
Feb 4 '08 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 14,534
To open a report to a specific record you need to set the criteria in the open event.

DoCmd.OpenReport "ReportName", , , "[FieldName]=" & Me!txtBoxField
Feb 5 '08 #2

Post your reply

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