Customize form based on query results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking to make a form that is auto customized for each record.

For exampe. If i have 25 possible items.
Record 1 might have 14 and 22 and
Record 2 might have 1, 2, 10, 15,16,21 and 25.

I want to make a form that will list the items in order for each record,
without leaving gaps- so using the if true then visible wont work, because
for example record 1 will only have 2 out of 25 while record 2 contains 7.
and there would be all the gaps between 1 and 25 that are not visible.

I had originally planned to use visible headers and place each item in a
header, if item = true, then header is visible. but i cannot figure out how
to add multiple headers to a form (like i can in a report).

Any help on creating this form would be helpful! thanks!
 
This can be done but it might turn into a maintenance nightmare if the data
ever changes. You could also have a separate form for each type of data.

If you want to do it your way, you need to look at the properties of a
control on a form like TOP, LEFT AND VISIBLE. You will have all your controls
defined on the form but all with VISIBLE = False. As each type of data is
read you will change the TOP and LEFT properties of each control to position
them where you need them and then set them all to VISIBLE = True. You also
have to make sure you set all others back to VISIBLE = False.

Dorian
 
hmm ok thats kinda what i was thinking... hopin to find an easier way =P
quick question, do you know the syntax for access 2003 for adjusting top and
left... is it similar syntax to visible? thanks.
 
well got it to work yesterday... coding actually wasnt half as bad as I
expected... gotta love <ctrl + v> ;-)
thanks for your help!
 
Back
Top