changing the table that a form gets data from

[emcf]

how do i change the table that a form gets its data from? I want to keep exactly the same format and I have exactly the same table structure and field names.

 

[emcf]

Thanks Pat,

i've now set it up using a query on the original table - makes life a lot simpler!

 

[emcf]

Now that I have got a form using a query from a table is there any way I can allow the form to add records to the table?
on the form properties I have set the 'allow additions' to yes but I still cannot add a new record.....anyone know where I am going wrong???

 

[emcf]

Pat,

tried to update the table by altering info in the query itself - access would not allow this and said 'this record set is not updatable'.

 

[emcf]

Problem sorted! in the query design view i had added another related table to bring through department names....i didn't actually need this - all i had to do instead was to type in the primary key number of the department rather than its name in the query in order to filter the records. the query and form now filter out the correct records and I can update the main table through the form! good start to a monday morning!