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

Parameter defaults in Access Reports

P: 2
Hi there,

I have written a report in Access 2000 to generate a disposal certificate. The report reads the equipment information from a query but requires the names of individuals who have carried out certain duties to be entered via text boxes. Normally the individuals don't vary and it becomes a chore to repeat the same entries again and again!

How can I set default values for these text boxes. Is this the best way to approach the problem?

I have a very limited knowledge of VB and if this is the solution I will need idiot instructions!

Many thanks in anticipation.
Sep 18 '07 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi there,

I have written a report in Access 2000 to generate a disposal certificate. The report reads the equipment information from a query but requires the names of individuals who have carried out certain duties to be entered via text boxes. Normally the individuals don't vary and it becomes a chore to repeat the same entries again and again!

How can I set default values for these text boxes. Is this the best way to approach the problem?

I have a very limited knowledge of VB and if this is the solution I will need idiot instructions!

Many thanks in anticipation.
Create a table to hold all the user names. Now change your textboxes to comboboxes which use the table as the row source. Make sure the combobox control source is still set to the appropriate fields.
Sep 19 '07 #2

P: 2
Thanks, but that didn't seem to work. I can change 'text' to 'combo' and change the source appropriately but it doesn't carry through to anything useful when I run the report. In my original version the prompts look and behave like the prompts for parameters in a query. What I would like, if possible, is the prompt behaving as a 'combo'.

Perhaps this is a case of 'if you're going there, I wouldn't start from here'!
Sep 19 '07 #3

Post your reply

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