About Rob Henderson Expertise I can answer most MS Access design questions. I also welcome questions on database design and implementation and VBA programming questions.
I also have expierence in application design for all the Office components (Excel, Outlook, etc).
Question My experience with Access has been centered around building tables, importing/linking tables (Excel, ODBC databases) and creating queries to extract data. I'm familiar with all types of queries - design, delete, update, append, make table, etc. I've used macros to execute multiple or consecutive commands/queries. Now, however, I'm attempting to work with FORMS and I just can't seem to figure out how to get started. I want to create a form that will be BOUND to one rather large table. I want the form to allow our salesmen to open the form and then use drop-down menus to pick customer information whenever a pricing adjustment is required for that customer, suggest the new price, and then have a new line added to the table with some sort of date stamp so that it will be easy to distinguish the old information from the new. Is this doable? My biggest problem is I can't seem to figure out how to get drop down menus onto the form! I'm sure if I could just get that far a few other things would start falling into place. I've designed forms before, but they were strictly for calling up existing information...not adding back to the table the form is BOUND to. Any help you can give would be appreciated. Thanks! Steve
Answer Hi
This is most certainly do able.
As far as your combo box design goes - if you set the field in the table to be combo instead of textbox any controls you create based on this field will inherit the combo properties.
A combo in your instance is just another type of bound field.
The best way to do this is set the field properties in the table and then use the form wizard to build the form and take it from there.
