Can we split a form

[Guest_imported]

Hello everyone!

Supposing that there is a table and a form associated with it, can we split the form into three-four smaller forms and link them all to a record in a table?(During data entry!). I mean instead of using a huge form, can we use multiple forms that feed data into a single record? Is it a reliable design? Please give me your answers as this is bugging me since a long time.

Thanks!
Rony

 

[ghubbell]

Also answered in that mess of a thread702-66299 ...
Rony,
Why sure you can. I've done this just to get rid of that nagging "Use fewer controls" message when you run the analyzer on your forms. Trick is you should save the record before you open the second form, open the second form off the first etc... Soooo you have to be careful that the data on the first form is enough to satisfy what is required in the table to save the record. I suppose if you wanted to have all the forms running at once you could play with events like "Lost Focus~Got Focus~Activate~Deactivate" to handle the saving chores.... ! Gord
ghubbell@total.net

 

[dpfeffer]

How about using tabs on your form?

 

[Lightning]

Another way is to use page breaks in your form and use code to display each page as required. You still have "one huge form", but your users only see a small part of it at any one time. Saves on synchronising separate forms.

Lightning