combo selection and saving data

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
if the user selection is office
i want the all the information to be saved on table office
if the user selection is stores
i want the all the information to be saved on table stores
in other words what ever the user choice of department i want the data to go
to that particular table
is this possible?
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
form and tables 1
Crating User Form to Add Names 1
Generated text copies into another template 0
Help creating a search form in Access XP 0
Adding data to MS Access from csv file 0

Top