Command buttons and opening forms

[SaraMegan]

I'm trying to re-vamp my forms to make them easier for the user, and less to look at. Right now I have a three-tab crowded form. What I would like is a one-page form that has command buttons which open another form where they can view and edit other information on the case.

For example, the main form has the business/claimant name, ID, case type, attorney, cross reference, and case file tracking information. It also has a button which says "Edit Contact information" and that opens a form which displays the name, id, case type (which aren't able to be edited) and fields for addresses and phone numbers. Another button would open up some other aspect of the case, like it's closeout information or court information.

Is this practical, or should I stick with what I had? Also, is it possible for the form linked to on command could open the same record currently being viewed instead of always coming up on the first file?

Please speak simply to me, I'm not a programmer.

Thanks very much in advance.

--Sara

 

[Rich]

Try downloading some of the sample db's from the MS download site, Solutions and the Forms sample db's will give plenty of examples for you

 

[ColinEssex]

Hi Sara

I've got some code that makes a form open to the last record viewed instead of the first one in the table. Would this help you?

Email me if you would like it

Col

 

[SaraMegan]

Rich - Thanks, I'm exploring that Microsoft stuff right now. Hopefully it has what I need. If not, maybe it'll help me figure something out.

Col - The e-mail has been sent. I'd love some code. The more stuff, the merrier!

--Sara