Hi All,
I'm hoping you could help me here.
I want to save selected areas on a form into the relevant fields in a table and am clueless how to after creating row sources not related to the form I require the information store in i.e. one dependent combo box fulling event names into it when events is selected as request type; this information is pulled from the events table, not the request table where I require it to be stored.
The user selects the request Type as 'Company' from the first combo box, the dependent combo box below then lists, only, the CompanyNames from that are available in the database. The user then goes down the form filling in the other relevant areas, etc, etc. When the user then clicks Save Request, the event will store all the required information in the required fields. What is vital is that the company name selected will store the relevant id the company id field in the requests table.
Any help would be greatly appreciated!
Thanks all
I'm hoping you could help me here.
I want to save selected areas on a form into the relevant fields in a table and am clueless how to after creating row sources not related to the form I require the information store in i.e. one dependent combo box fulling event names into it when events is selected as request type; this information is pulled from the events table, not the request table where I require it to be stored.
- My first question would be how do I assign a button to store the relevant information from my requests form into my requests table.
- And my second question/problem is that I want the value of one of the dependent boxes to store as and ID in the table request table. For example;
The user selects the request Type as 'Company' from the first combo box, the dependent combo box below then lists, only, the CompanyNames from that are available in the database. The user then goes down the form filling in the other relevant areas, etc, etc. When the user then clicks Save Request, the event will store all the required information in the required fields. What is vital is that the company name selected will store the relevant id the company id field in the requests table.
Any help would be greatly appreciated!
Thanks all