form and tables

  • Thread starter Thread starter kev carter
  • Start date Start date
K

kev carter

hi
i have a database that has several tables in it
i only have one form at the moment
the form contains comboxs, text boxes etc
one combo box contain departments
combobox on form
office
stores
shop floor

i have several tables
example
table [office]
dept fault cost

table[stores]
dept fault cost


the user makes a selection from combo on input

is it possible to save the data entered by the user to a table based on
what is selected in the combo box?
my knowledge of access is very limited

thanks in advance
kevin
 
If you use the wizard tp build the ComboBox, it should ask you if you want to store the selected value in a field in your source table

----- kev carter wrote: ----

h
i have a database that has several tables in i
i only have one form at the momen
the form contains comboxs, text boxes et
one combo box contain department
combobox on for
offic
store
shop floo

i have several table
exampl
table [office
dept fault cos

table[stores
dept fault cos


the user makes a selection from combo on inpu

is it possible to save the data entered by the user to a table based o
what is selected in the combo box
my knowledge of access is very limite

thanks in advanc
kevi
 
Back
Top