Hye
I have a very basic question which i hope someone can help me resolve.
I have one huge table with details of supplier. As first step of creating a user interface i just want to create a normal form for users to see details.
Table has details of suppliers i.e. name, contact no, email, etc.
I just want a form where user can select name of supplier from drop down menu and other information such as contact no, email for that supplier is displayed. All details are within one table only.
I have created a main form and a sub form. I have put a combobox in main form to select from name of supplier. But i cant get subform to work. Subform details do not update based on what is selected in drop down menu in the main form.
Hope above makes sense...
Please help
Cheers
I have a very basic question which i hope someone can help me resolve.
I have one huge table with details of supplier. As first step of creating a user interface i just want to create a normal form for users to see details.
Table has details of suppliers i.e. name, contact no, email, etc.
I just want a form where user can select name of supplier from drop down menu and other information such as contact no, email for that supplier is displayed. All details are within one table only.
I have created a main form and a sub form. I have put a combobox in main form to select from name of supplier. But i cant get subform to work. Subform details do not update based on what is selected in drop down menu in the main form.
Hope above makes sense...
Please help
Cheers