form and tables

[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

 

[Guest]

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