This is all based on a customer table.
I have form with two unbound fields where the user enters a surname and postcode.
A query based on the customer table, displays the results of this search in a form and allows the user to either go to a specific record displayed in the main customer form, or create a new records again using the customer form.
However, in reality, if you try and create a new record (DoCmd OpenForm AcAdd etc) you get a blank form apart form teh header and footer - no buttons, fields, label etc
If you select a specific customer, when you are taken to the customer form, you cannot (DoCmd AcEdit etc) edit the customer record due to the recordset not being updateable
Now I'm guessing that I need to somehow re-set the query used to filter down the customer list to those with that surname at that postcode... but I've no idea how or if this is the correct answer
I have form with two unbound fields where the user enters a surname and postcode.
A query based on the customer table, displays the results of this search in a form and allows the user to either go to a specific record displayed in the main customer form, or create a new records again using the customer form.
However, in reality, if you try and create a new record (DoCmd OpenForm AcAdd etc) you get a blank form apart form teh header and footer - no buttons, fields, label etc
If you select a specific customer, when you are taken to the customer form, you cannot (DoCmd AcEdit etc) edit the customer record due to the recordset not being updateable
Now I'm guessing that I need to somehow re-set the query used to filter down the customer list to those with that surname at that postcode... but I've no idea how or if this is the correct answer
