Hi,
I have a Table Tbl_Starter_Leaver and Tbl_Dept. My main form consists of all the fields from source table and this works fine. Incidentally, 70 to 80 depts want to enter data for their respective departments and as such they would only want to see their own departments records. So as the theory goes I think the way forward would be to use a combobox which has a list of the current depts who have entered data into the system.
Just to test this I have managed to get a parameterised query working (Hurrah) : Qry_starter_leaver.
I understand that I can now :
1) Setup the combobox at the top header of the main Form
2) Set the Record Source of my main form to be the results of the parameterised query....
I would like to ask how this will work in practice ...
(I have been told Tbl_starter_leaver are synonymous to Qry_starter_leaver so any insert into the query result would insert a records into the table ?
At the moment new records are inserted into the Tbl_Starter_Leaver table where/how will records be inserted into the table if the query results are set as the record source ?
Hope the question is clear. Thanks in advance.