ok, so I have a form with an unbound combox in the header and two bound text boxes in the detail section of the form.
I am simply using the form to lookup data (in the two textboxes) based on selections made in the combobox.
All working fine except, when I open the form the recordset is loaded so I immediately see data (the first record) in the text boxes.
What I would like to do is open the form and see nothing in the text boxes (so, a clean recordset). I can then perform my search via the combobox and voila!, the textboxes are populated.
I know it's something simple but perhaps I can't accomplish this with form properties and need to go down the code path "me.recordset....??????"
Any ideas?
I am simply using the form to lookup data (in the two textboxes) based on selections made in the combobox.
All working fine except, when I open the form the recordset is loaded so I immediately see data (the first record) in the text boxes.
What I would like to do is open the form and see nothing in the text boxes (so, a clean recordset). I can then perform my search via the combobox and voila!, the textboxes are populated.
I know it's something simple but perhaps I can't accomplish this with form properties and need to go down the code path "me.recordset....??????"
Any ideas?