If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combo box in Forms
I am trying to create a data entry form that requires a lot of information
like training codes and job types. All information is saved to a table "Data Entry". The problem I am having is where I want the user to be able to select a job type or training code from a combo box instead of trying to remember what each one is. I have a table listing all job types and a table listing all training codes. All tables share relationships. When I go to tab through the created form, entering all required info and selecting items from the combo box, I get a error saying value for that field (job types or training code) cannot have a null value. The table "Data Entry" has only training codes and job types that have been entered. The table "Job Types" lists every job type and the table 'training codes" lists all training codes. This is why I need to pull from those tables. Is there a way this can be done? |
#2
|
|||
|
|||
Combo box in Forms
gday
Hope I understand you correctly refer to the property dialog for each of the combo boxes in the Data Entry form open in Design Mode: Form:- Record source - Data Entry (table or query name) ComboBox for JobTypes:- ControlSource - JobType (Field name from Data Entry Table or Query) Row Source Type - Table/Query Row Source - SELECT JobType FROM DataEntry (query) Column Count - 1 (if only wanting the one field displayed in the dropdown) Column Widths - (use this to set the width of the columns displaying in the drop down if more than one column or field selected in the RowSource) Bound Column - 1 etc Combobox for TrainingCodes:- similar to JobTypes if you are getting the idea... tip! try using non spaced names for objects or use an "Underline" to separate names if you must. It makes it easier to code and refer to objects and also avoid mistakes. ie Data Entry shoile be either DataEntry or Data_Entry hope this helps a little..... cheers jeff "GMac" wrote in message ... I am trying to create a data entry form that requires a lot of information like training codes and job types. All information is saved to a table "Data Entry". The problem I am having is where I want the user to be able to select a job type or training code from a combo box instead of trying to remember what each one is. I have a table listing all job types and a table listing all training codes. All tables share relationships. When I go to tab through the created form, entering all required info and selecting items from the combo box, I get a error saying value for that field (job types or training code) cannot have a null value. The table "Data Entry" has only training codes and job types that have been entered. The table "Job Types" lists every job type and the table 'training codes" lists all training codes. This is why I need to pull from those tables. Is there a way this can be done? |
Thread Tools | |
Display Modes | |
|
|