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

create textbox dynamically for a report through VBA

P: 15
Hi All,

I'm a newbie. I know this question might sound simple, but i haven't been able to resolve it, so i seek your adivce.

I'm trying to add a dynamic textbox to a report through VBA.

Background: This report is for a library database, In which a user's request can consist of multiple signouts of different manuals. Therefore say for Request 1, the user signs out Manual 1and Manual 2. I want to be able to programatically create another textbox and place the name of Manuals 2 in there for that record. That way, if a request has 10 Manuals attached to it, It created 10 textboxes to place each manual's name in.

Highly appreciate the help folks.

Thanks
Nov 30 '06 #1
Share this Question
Share on Google+
2 Replies


nico5038
Expert 2.5K+
P: 3,072
Hmm, I would probably offer the user a ReportRequest form with a datasheet subform with a table with the Manuals and a PrintYesNo field.

Now the user can check the needed manual(s) and for the report I can build a query joining the table from the datasheet subform by the Manual ID and add the criteria that the PrintYesNo field is True.

Now for the report use this query and only checked manuals will be printed.

Getting the idea ?

Nic;o)
Nov 30 '06 #2

P: 15
Thanks, Nico.

That's a much better way then what i was thinking of.

Regards.
Nov 30 '06 #3

Post your reply

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