Saving information entered on forms using option boxes

[sdollen]

Can someone direct me to some easy to understand directions/examples of how to create a data input form that uses selection boxes?

Here is a made up example of what I'm trying to do...

If I have contracts that I sign with my customers, and there are 5 specific contract types which a customer can have multiple contacts (this is make believe now). So, I want to make a form that I enter new customer data on.. and have selection boxes so that I can select any/all contract types the customer will have...

What is the best way to report that in the "tblCustomer" ? And, then when I carry that info to a report, can I have one field titled "contract types" and have any/all listed with a comma between types?

I hope this makes sense?

Thanks for any help.

-Stefan

 

[JeremyNYC]

Stefan,

The way to do this is to create a frame and put the option buttons in there. Then bind the frame to the proper field, not the individual buttons.

A more flexible solution, and one that uses less screen space, is to use a combo box. This way, if there is all of a sudden a sixth type of cotnract available, or if the name of one of the contract types has to be altered, you can make the change in your data table and not have to touch the design of your form.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.