change contents of boxes after change in combox 
Author Message
 change contents of boxes after change in combox


MSAccess97 & WindowsNT

Here is the problem:
I have a form which displays information about an user. If you click on a
command button, a subforms for holidays appears, if you click on another
button, the previous subform disappears and another appears for flights
... yes, I didn't want to work with tabs ....

Besides that, I would like to have a drop down box (combobox) from which
the database user can select a name, and then the appropriate record will
appear .. i.e.:

Choose User: .the combox..

Name: shadedbox         firstname: shadedbox

phone: shadedbox
email: shadedbox


|Room for subforms

Is this possible? if so, can someone show me the way? .... I really need
help on this one .....

Thanks in advance,


Fri, 04 Jul 2003 00:12:23 GMT  
 change contents of boxes after change in combox
    Use the wizard to set up the combo box. Build a subform showing your
'name' etc. fields.
Then link the subform to the combo box.  Make sure that the data source for
the subform also includes a field that is in the combo box.


Simeon Theobald,
  Palmerston North,
     New Zealand.

Sat, 05 Jul 2003 01:09:11 GMT  
 [ 2 post ] 

 Relevant Pages 

1. Combox change event

2. Rich text box - how to change contents in code

3. Changing a field's contents using VBA

4. Use VBA to change textbox/label contents in report

5. Change Access default color scheme based on content of a variable

6. CommandBarComboBox Change event (content not saved when losing focus)

7. Change textbox contents from VBA

8. content in folder changed alert

9. how to change Content-Type/charset

10. Changing a field's contents in VBA

11. Text Control loses content when form page changes

12. Change content in a field within a footer


Powered by phpBB® Forum Software