Combo box in Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top