Parameter defaults in Access Reports

[David Ball]

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.

[MMcCarthy]

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.

[David Ball]

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'!