My current project requires me to create part of a form that is
created on the fly. The project consists a list of entries to an
event. The name and address and such is easy. The design is detup so
that the creater of the even can make their own event in the database.
When they do so a 2 tables are created. One for the entries such as
names and the other is for the parameters of each event.
The creator then goes in and makes each event giving it a name and
setting the parameters. This is all easy for me and works fine. When a
user goes into to start adding entries they put in the personal info
and using a series of check marks check what the events that person is
in.
How do I create a series of option boxes, or check boxes when I don't
the know names of the events or even the number of the events?
(Actually I may want to be using check boxes instead). Also an event
maybe added after entries are being started been taken.
I do know how to create select statements, change properties of form
elements and such. I also know the table name where the name of the
events occur. The user selects it so thats not a problem.
What has me stumped is creating form elements using VB in access 2000.
At this point I need a direction to look or even a simple example.
Thank you.
PS The actual design of the form and layout works wonderfully. We used
it this summer at a real event. The problem is that the tables and
queries were only for that event so we are building something that
anyone can use. In reality we only used the backend features of access
since myself and a friend were running it.