Hi All,
I have used a combo box wizard to find a record in a table (tblMemberDetails). I have 2 fields txtMemberId and txtMemberName (I select a member ID ( 001 to ...) to find a member name on a form frmSelectMember
However, when the form loads the 1st record in the table is displayed in the txtMemberName field but the txtMemebrID field is blank.(I tried it the other way around and the situation is reversed)
I have tried to set the value to null using the OnActivate event of the form but Access does not allow this. How do I get the form to display both fields as blanks when it is loaded/activated?
Thanks in advance.
I have used a combo box wizard to find a record in a table (tblMemberDetails). I have 2 fields txtMemberId and txtMemberName (I select a member ID ( 001 to ...) to find a member name on a form frmSelectMember
However, when the form loads the 1st record in the table is displayed in the txtMemberName field but the txtMemebrID field is blank.(I tried it the other way around and the situation is reversed)
I have tried to set the value to null using the OnActivate event of the form but Access does not allow this. How do I get the form to display both fields as blanks when it is loaded/activated?
Thanks in advance.
