how do i let the user set up a form

D

DAVIDPEOVER

i was looking to let the user answer a few questions in order to set up a form.

eg. how many doctors are working that day?
how many time slots for that day?
etc.

then once the user had answered these questions a form would be created with
the various controls depending on how many docotrs and time slots were
required.

is this possible to do?
 
S

Scott McDaniel

You can create forms, assuming that your user has an .mdb file. Check online
help for these topics:

CreateForm
CreateControl

It's easiest if you have a "template" to base your form from.

However, I've rarely found the need for endusers to create forms at runtime
.... what are you trying to do?
 
J

John Vinson

i was looking to let the user answer a few questions in order to set up a form.

eg. how many doctors are working that day?
how many time slots for that day?
etc.

then once the user had answered these questions a form would be created with
the various controls depending on how many docotrs and time slots were
required.

is this possible to do?
Click to expand...

It's possible... but as noted, it's difficult and probably NOT the
best way to interact with the user!

If you have one (day) to many (doctors or timeslots) relationships,
the table design should be set up to model that relationship. It
sounds like you want to create five textboxes if there are five
doctors on a given day - this is almost certainly a Bad Idea! You'll
do better to use a Form with a continous Subform on it, which will
allow the user to see and enter any number of doctors (or timeslots,
or both on two subforms).

If I'm missing something, please post back with a description of your
table structure and what you're trying to accomplish (and why you need
to do it that way).

John W. Vinson[MVP]
 
Top